So how does 'Trusted_Connection work? Does it try to match
the SQL user against the person logged into Windows?




>IMHO that's the secure one and you should have whenever possible. SQL authentication (username and password) is not the recommended one but still yet the most seen in examples.
>Cetin
>
>>Is there any reason to not have 'Trusted_connection=yes' in my
>>connection string by default?
>>
>>
>>
>>>>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