newby question about connection strings

[Guest]

Hi
Here is a sample connection string from one of my study guides
"data source=bean; initial catalog=Northwind;integrated security=SSPI; persist security info=false

What exactly does the 'SSPI' mean? I can't seem to find out anywhere

 

[William \(Bill\) Vaughn]

3 minutes in Google returned the following : Security System Provider
Interface (SSPI)
http://www.microsoft.com/china/windowsxp/zip/PKIEnhancements.doc

Basically, SSPI security uses the Windows Active Directory to validate the
connection. It extracts the credentials for the current user (or ASPNET)
from the client system and uses this as a "User ID" against the backend
server. It assumes that you have previously setup an account on the target
server (such as SQL Server) and granted permission to access the selected
Initial Catalog database.

I hope this helps...
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Miha Markic]

**3** minutes in Google returned the following : Security System Provider
Interface (SSPI)

What took you so long? ;-)