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:
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. |
Connections Accounts
Database Connections
This table contains the following information:
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. |
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. |
Connections SQL Server Connections
SQL Database Permissions
| Item | Description |
|---|---|
| Result | Shows the status of the permission of the service account to the database. |
Connections SQL Database Permissions
SQL Database Version
| Item | Description |
|---|---|
| Result | Shows the current status of the database schema deployed. |
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. |
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 SQL Server Analysis Services. |
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. |
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. |
Connections Available Cubes
Recommended Reading
The following article can help to configure the Connections properly.