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