# Configuring Database Connection Strings

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

  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.

    Example
    <connectionStrings>
    	 <add name="SqlServer"  providerName="System.Data.SqlClient" connectionString="Data Source=MNL164WIN;Initial Catalog=9611; 
    	 Integrated Security=True; MultipleActiveResultSets=True;"/>
    	 <add name="OlapServer" providerName="Microsoft.AnalysisServices.AdomdClient" 
    	 connectionString="data source=MNL164WIN;initial catalog=9611"/>
    	 <add name="TabularServer" providerName="Microsoft.AnalysisServices.AdomdClient"
    	 connectionString="Data Source=MNL3206WIN\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.

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