difference between Integrated Security=True and Integrated Security=SSPI

  • Thread starter Thread starter John Harkin
  • Start date Start date
J

John Harkin

Hi ,
Is there any difference between
Integrated Security=True and Integrated Security=SSPI?
The docs seem to indicate they are the same but i have seen different
behaviour when connecting to sql server using each in the connection
string.
All info welcome.
Regards
John
 
AFAIK they are identical, it's just a matter of which sytax you use in the
connection string. What behavior differences are you experiencing.
 
I have experienced 2 different behaviours when using these 2 different
settings. I have built a DLL based on the MS Data Access Application
Block and I am using the SqlConnection object to create a connection to
the DB. With the setting "Server=MyServer;Database=Pubs;Integrated
Security=True" the following error is reported "SQL server does not
exist or Access Denied".
However when using the setting "Server=MyServer;Database=Pubs;Integrated
Security=SSPI", the connection is successful. Why the 2 different
behaviours?
 
Not sure but could be because it mixes "styles".

I suspect that server/database/sspi (ODBC) and data source/initial
catalog/yes (OLEDB) are working together but that you can't mix them.

What if you try "Data Source=MyServer;Initial Catalog=Pubs;Integrated
Security=Yes" ?

Patrice
 
If you use the syntax with Server, then it's Trusted_Connection = True or
Integrated Security = SSPI. I think you're mixing the snytaxes there.
Integrated Security isn't a true or false property , you need to specify
what it is, and Integrated Security is provided through SSPI Security
Support Provider Interface . This exposes a public interface for
communication between transport level apps. SSPI is a specific interface
whereas True isn't.

That's ultimately the reason for differing behavior.

HTH,

BIll
 
Hi,
Could you explain what you mean by mixing "styles"?
I appreciate there is probably different connections strings for Odbc,
Oledb and .net Sql Provider but docs don't seem to differentiate and
interchange between e.g Truster Connection and Integrated security.
I want to use .net Sql Provider with Integrated security .

Regards
 
Check out www.connectionstrings.com for instance, There are different ways
to create your connection string.. ie one begins with "Data Source=" the
other begins with "Sever=" Anyway, Integrated Security isn't true or false,
but Trusted Connection is, so simply if you use "Integrated Security" you'll
need to specify it, which is SSPI not true. If you answer Trusted
Connection with SSPI, you won't get what you want either.
 
Back
Top