Is there a difference between Integrated Security = True and Integrated Security = SSPI when used in the connection string. I could sense some difference between them throug i went through some document which says there is no difference.
Asked
Active
Viewed 1,731 times
0
-
See existing excellent answer here: http://stackoverflow.com/questions/1229691/difference-between-integrated-security-true-and-integrated-security-sspi They are equivalent in terms of the way authentication is performed but 'Integrated Security=SSPI' will try authenticate with user/pass if provided whereas 'Integrated Security=true' will just try straight away with current user account. – Lisa Jul 10 '11 at 08:52
-
@Lisa do you have a test case or reference that indictes that SSPI will use user/pass in the connection string? – Nick.Mc Aug 14 '15 at 06:20
-
@Nick.McDermaid Sorry no. Being in Java-based development for the past 4 years, I've not even touched SQL Server or C# in the meantime so it's not fresh in my mind. – Lisa Aug 19 '15 at 00:14