Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SSPI Property

SSPI Property

SQL Server 2000

SSPI Property

This property determines the security package that will be used during the session.

Property Name


Property ID



The value of this property corresponds to the name of a security package. You can use the Security Support Provider Interface (SSPI) EnumerateSecurityPackages function to enumerate the providers that are supported on a given computer.

Microsoft™ SQL Server® 2000 Analysis Services supports the following packages:

  • Negotiate

  • Kerberos

  • NTLM

  • Anonymous User

Suppose that the Kerberos security provider is the security package used for authentication in the domain on which a particular client application must run. The following code opens a connection using this provider and then displays a dialog box to complete the connection:

Dim cn as New ADODB.Connection
cn="Provider=MSOLAP; SSPI=Negotiate; Prompt=1"
© 2015 Microsoft