Export (0) Print
Expand All
Expand Minimize

SSPI Property

SQL Server 2000

SSPI Property

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

Property Name

SSPI

Property ID

DBPROP_MSMD_SSPI

Remarks

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
Example

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"
cn.open
Show:
© 2014 Microsoft