Authentication of Connections
The Analysis server authenticates end users when they attempt to connect to an Analysis server through Microsoft® Internet Information Services (IIS). These connections are characterized by:
- Connection strings containing a Data Source property value equivalent to a URL.
- Use of Hypertext Transfer Protocol (HTTP).
Note Connections through HTTP and IIS from Analysis Manager or from client applications connecting through PivotTable® Service are available only if you install Analysis Services for Microsoft SQL Server™ 2000 Enterprise Edition.
Direct connections can also be attempted. For more information, see Authentication of Direct Connections.
When an end user attempts to connect to an Analysis server through IIS, Analysis Services relies on the authentication on IIS. If authentication on IIS is successful, authentication on the Analysis server is successful, and the end user is allowed to connect to the Analysis server. If authentication on IIS is unsuccessful, authentication on the Analysis server is unsuccessful, and the end user is not allowed to connect to the Analysis server.
IIS provides several authentication methods. For example, a user logon and password can be used for Basic authentication for HTTP or secure HTTP connections. Other methods can be integrated with roles in Analysis Services. For more information, see the IIS documentation.