Integrated Security=true; doesn't work in all SQL providers, it throws an exception when used with the
OleDb provider. So basically
Integrated Security=SSPI; is preferred since works with both
SQLClient &
OleDB provider.
Other options are:
Provider | Syntax |
---|
SqlClient | Integrated Security=true; -- or -- Integrated Security=SSPI; |
OleDb | Integrated Security=SSPI; |
Odbc | Trusted_Connection=yes; |
OracleClient | Integrated Security=yes; |
refer:
http://msdn.microsoft.com/en-us/library/vstudio/ms254500%28v=vs.100%29.aspx for more details.