Database Connection Strings Configuration

The Database Connection Strings file contains the settings for SQL and OLAP database connections.

warning

Do not alter the format of the contents of the file. The file uses a static format and altering the format might cause malfunctions.

1. Go to the Configuration directory, located by default in C:\Program Files\OpeniT\Analysis Server\Configuration.

2. Open the ConnectionStrings.config configuration file.

   The file contains add entries.

   ConnectionStrings.config

   <connectionStrings>
      <add name="SqlServer"  providerName="System.Data.SqlClient" connectionString="Data Source=DESKTOP123WIN;Initial Catalog=9611; Integrated Security=True; MultipleActiveResultSets=True;"/>
      <add name="OlapServer" providerName="Microsoft.AnalysisServices.AdomdClient" connectionString="data source=DESKTOP123WIN;initial catalog=9611"/>
      <add name="TabularServer" providerName="Microsoft.AnalysisServices.AdomdClient" connectionString="Data Source=DESKTOP234WIN\SQL2019STAB; Initial Catalog=Tabular;"/>
      <add name="AasSqlServer" connectionString="Data Source=asazure://centralus.azure.windows.net/astabular; Initial Catalog=OpeniT;"/>
   </connectionStrings>

   SqlServer
   The entry containing database connection details for SQL Server with the following attributes:

   • providerName
     The name of the provider used in accessing the data. The default value is System.Data.SqlClient.

   • connectionString
     The string that specifies the database connection details.

     Key	Description
     Data Source	The SQL Server host name or IP address provided during the installation.
     Initial Catalog	The name of the SQL database provided during the installation.
     Integrated Security	Triggers the connection to use the current Windows account credentials for authentication. The default value is true.
     MultipleActiveResultSets	Allows you to have active query result sets concurrently, enabling the execution of multiple batches on a single connection.The default value is true.

     SQL Server Connection String

   OlapServer
   The entry containing database connection details for OLAP Server with the following attributes:

   • providerName
     The name of the provider used in accessing the data. The default value is Microsoft.AnalysisServices.AdomdClient.

   • connectionString
     The string that specifies the database connection details.

     Key	Description
     Data Source	The OLAP Server host name or IP address provided during the installation.
     Initial catalog	The name of the Tabular database provided during the installation.

     OLAP Server Connection String

   TabularServer
   The entry containing database connection details for Tabular Server with the following attributes:

   • providerName
     The name of the provider used in accessing the data. The default value is Microsoft.AnalysisServices.AdomdClient.

   • connectionString
     The string that specifies the database connection details.

     Key	Description
     Data Source	The Server Name of the created Azure Analysis Services server.
     Initial Catalog	The name of the SQL database provided during the installation.

     Tabular Server Connection String

   AasSqlServer
   The entry containing database connection details for Azure Sql Server with the following attributes:

   • connectionString
     The string that specifies the database connection details.

     Key	Description
     Data Source	The Server Name of the created Azure SQL Database server.
     Initial Catalog	The name of the Azure SQL database provided during the installation.

     Azure Sql Server Connection String

3. Modify the desired entry with a valid value.

4. Save the changes.