Hello friend!

The beta release of Open iT version 10.1 is now available!
Try it out and help us enhance your Open iT experience. Contact support@openit.com to get started.

# 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

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

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