# Connections

The Connections page contains various details about the current database and web connections of Analysis Server.

# Service Account and Web Authentication

This table contains the following information:

 Analysis Server Administration: Connections Service Account

Analysis Server Administration: Connections Service Account

Account Description
Service Account The username and authentication type used to run background services for Analysis Server.
Service Account Service Principal Name A unique identifier used by Kerberos authentication to associate the service account to the service instance.
Current Web User The username of the user currently accessing the web interface with authentication type.
Current Web User Impersonated by the Service Account The username of the current web user impersonated by the service account.
Administration: Connections Accounts

# Database Connections

This table contains the following information:

 Analysis Server Administration: Connections Database Connections

Analysis Server Administration: Connections Database Connections

Column Name Description
Status Shows check (green) if the status of a certain test is valid or cross (red) if the test has errors.
Test Contains various tests related to database connections.Please see the description of each test in the section Database Connection Tests.
Description A brief description of each item.
Administration: Connections Database Connections

# Database Connection Tests

# SQL Server Connections

Item Description
Connection String A string used to connect to SQL Server.
Result Shows the status when connecting to SQL Server using the connection string.
Status Shows the current connection status to the SQL Server if it is open or closed.
Instance Instance name used to connect to SQL Server.
Version Shows the version of the SQL Server.
Database The SQL database name.
Size The current size of the SQL database.
Administration: Connections SQL Server Connections

# SQL Database Permissions

Item Description
Result Shows the status of the permission of the service account to the database.
Administration: Connections SQL Database Permissions

# SQL Database Version

Item Description
Result Shows the current status of the database schema deployed.
Administration: Connections SQL Database Version

# SQL DB Recovery

Item Description
Result Shows the status of the database recovery used.
Current Model A string representing the currently used database recovery.
Administration: Connections SQL DB Recovery

# OLAP Server Connection

Item Description
Connection String Used to connect to SQL Server Analysis Services.
Result Shows the status when connecting to SQL Server Analysis Services using the connection string.
Connection Status Shows the status of the current connection to the SQL Server Analysis Services if it is open or closed.
Server Version Shows the version of the SQL Server Analysis Services.
Provider Version Shows the version of the OLAP provider used by the SQL Server.
Client Version Shows the version of the SQL client accessing the the SQL Server Analysis Services.
Administration: Connections OLAP Server Connection

# Olap Database

Item Description
Database The SQL Server Analysis Services database name.
Result Shows the connection status to the OLAP database.
Administration: Connections Olap Database

# Available Cubes

List of available deployed OLAP cubes. It gives the name and the last date and time of processing.

Item Description
Cube 1 Applications Cube. Includes the last processing time of the cube.
Cube 2 Storage Cube. Includes the last processing time of the cube.
Administration: Connections Available Cubes

# Recommended Reading

The following article can help to configure the Connections properly.

   Configuring Database Connection Strings

We value your feedback!

Please take a few minutes to complete our survey and share your thoughts on your recent experience with our documentation.

Take survey

Close