Use NT Security instead of SQL Security
Hi Erik,
The difference is:
if you are using SQLOLEDB in connection string then you
should use "Integrated Security=SSPI"
if you are using MSDASQLin connection string then you
should use "Trusted_Connection=Yes"
Each provider has its own properties.
Check next link
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adosql/adoprg01_0ahx.asp
Val
Quote:
>-----Original Message-----
>Hi Val.
>Do you know what are the differences between "Integrated
Security=SSPI" and
>"Trusted_Connection=yes"? What I know is that both will
connect using NT
>authentication but when should I use one or another?
>Thanks.
>> Hi,
>> To connect, using integrated security, you need to
specify
>> Integrated Security=SSPI; parameter inside connection
>> string. But SQL Server should be properly configured to
>> use integrated security of Windows NT.
>> Val
>> >-----Original Message-----
>> >Currently, I have code in my VB6 application that
>> connects
>> >to a SQL Server database using a user name and password
>> >assigned in SQL Server. How can I connect using NT
>> >authentication?
>> >Thanks.
>> >Mark.
>> >.
>.
