Dear all,

I got problem where I tried to connect my program using VB6 to SQL Server database where I put in other machine.
The problem is if I connect the program with the local database in SQL in my pc(local), it works but error occurs if I connect it to the other machine.
This is the link I made to connect it if the database in my pc.
Provider=MSDataShape.1;Data Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=databasename;Data Source=local
It seems to work.
my question is that the same link if I want to connect it with the database put in the other machine?This is the error I got :
"Test Connection failed because of an error in initializing provider.Login failed for user 'admin'.Reason:Not associated with a trusted SQL Server connection."
Plz help..

You might want to take a look at this URL, this would help you in a way.
http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=32960

_________________________
-Vijay G
Strive for Perfection

i think you are trying to connect using "windows authentication". fpr this to work, the user curently logged on the machine where the client app runs, has to be able to connect to the sql server instance on the machine it tryies to connect to, and also to have the right to connect to the specified database.

a quick colution would be to add the "admin" user (that cannot login) to the machine running sql server, with the same password as the one on the client machine.

Hi Okinokiyo,

It appears to me the admin account you are using is local to the machine.

If the machines are in the same domain. Please check out your using a domain account and not a local machine account

Regards,

Jago