Connect to Analysis Services
This section provides an overview of the authentication methods supported by Analysis Services, client libraries used for connections, connection string properties, and how to set up or clear connections before taking a server offline.
Analysis Services connections
Analysis Services uses TCP as the network protocol and XML for Analysis (XMLA) as a communication protocol. At the lowest level, all of the client libraries provided with Analysis Services implement XMLA-over-TCP. Although it is possible to build applications based on raw XMLA, most applications and application developers use client libraries to take advantage of the object models and coding efficiencies that they provide.
Any discussion involving connectivity typically includes authentication. In contrast with other SQL Server features, Analysis Services supports Windows authentication exclusively. You cannot use SQL Server database authentication, claims authentication, forms-based authentication, or digest. More about authentication is provided in this section.
Connection Tasks
Task Description |
Topic |
|---|---|
If you are new to Analysis Services, read this topic to get started with the tools and applications most often used with Analysis Services. |
|
Analysis Services includes numerous server and database properties, allowing you to customize a connection for a specific application, independent of how the instance or database is configured. |
|
This topic is a brief introduction to the authentication methods used by Analysis Services. |
|
Many business intelligence solutions require impersonation to ensure that only authorized data is returned to each user. In this topic, learn the requirements for using impersonation. This topic also explains the steps for configuring Analysis Services for Kerberos constrained delegation. |
Configure Analysis Services for Kerberos constrained delegation |
Kerberos authentication requires a valid Service Principle Name (SPN) for services that impersonate or delegate user identities in multi-server solutions. Use the information in this topic to learn the construction and steps for SPN registration for Analysis Services. |
|
Basic authentication or cross-domain boundaries are two important reasons for configuring Analysis Services for HTTP access. |
Configure HTTP Access to Analysis Services on Internet Information Services (IIS) 7.0 |
Analysis Services provides three client libraries for accessing server operations or Analysis Services data. This topic offers a brief introduction to ADOMD.NET, Analysis Services Management Objects (AMO), and the Analysis Services OLE DB provider (MSOLAP). |
|
Clear existing connections and sessions before taking a server offline or conducting baseline performance tests. |
See Also
Reference
Configure Server Properties in Analysis Services