Hi,
I have two apps, both use integrated security. One works with the values set to true in the connection string and another with the value set to SSPI.
Why is the difference, as I knew about SSPI but not using True?
JD.
views:
5756answers:
1
+14
A:
According to Microsoft they are the same thing.
When false, User ID and Password are specified in the connection. When true, the current Windows account credentials are used for authentication. Recognized values are true, false, yes, no, and sspi (strongly recommended), which is equivalent to true.
cptScarlet
2009-08-04 20:23:53
Originally, I think there was a difference in that "True" used NTLM and "SSPI" used Kerberos, but they're now interchangeable.
rwmnau
2009-08-04 20:26:29
Thanks for the response.Any reason why it works with one and not the other? In fact, if recall correctly, the error obtained when I used "true" was about some driver (on a 2003 windows server with sql server express).JD.
JD
2009-08-05 07:46:12