>I'm creating connections to 2 databases, each on different servers.
>
>The first connection works. The second errors with:
>Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
>Reason: Not associated with a trusted SQL Server connection.
>
>When I look at login 'sa' in the Enterprise Manager, the password is filled in
>with a 10 character string.
>
>I did not set it, so I'm not sure whats going on.
>
>I'd like it to take the Windows login info.
>
>Can someone point me in the right direction?
>
>Thanks
Kevin,
It means you set SQL server to use windows authentication only and the server you're connecting to doesn't trust the windows account you use.
Can you connect with this?
lnHandle = SQLStringConnect('Driver=SQL server;server=servername;Trusted_connection=yes')
? m.lnHandle
SQLDisconnect(m.lnHandle)
Cetin