Export (0) Print
Expand All

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 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.

Task Description


If you are new to Analysis Services, read this topic to get started with the tools and applications most often used with Analysis Services.

Connect from client applications (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.

Connection String Properties (Analysis Services)

This topic is a brief introduction to the authentication methods used by Analysis Services.

Authentication methodologies supported 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.

SPN registration for an Analysis Services instance

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).

Data providers used for Analysis Services connections

Clear existing connections and sessions before taking a server offline or conducting baseline performance tests.

Disconnect Users and Sessions on Analysis Services Server

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft