What is the difference between Integrated Security = True and Integrated Security = SSPI?

Asked 2009-08-04T20:15:32.283

654

I have two apps that use Integrated Security. One assigns Integrated Security = true in the connection string, and the other sets Integrated Security = SSPI.

What is the difference between SSPI and true in the context of Integrated Security?

Edit Report

1 Answer

Integrated Security = False : User ID and Password are specified in the connection. Integrated Security = true : the current Windows account credentials are used for authentication.

Integrated Security = SSPI : this is equivalant to true.

We can avoid the username and password attributes from the connection string and use the Integrated Security

answered 2013-01-23T13:26:08.373

What is the difference between Integrated Security = True and Integrated Security = SSPI?

1 Answer

Your Answer