Specify MS SQL Server connection strings
Open the ConnectionStrings.config file in a text editor and specify the connection parameters (connectionStrings) for the restored database (name=”db”) and Redis Server (name=”redis”).
<?xml version="1.0" encoding="utf-8"?>
<connectionStrings>
<add name="db" connectionString="Data Source=[The database server name];
Initial Catalog=[The database name];
Persist Security Info=True; MultipleActiveResultSets=True;
Integrated Security=SSPI; Pooling = true; Max Pool Size = 100; Async = true" />
<add name="redis" connectionString="host=[Computer name];db=[Redis DB number];port=6379;
maxReadPoolSize=10;maxWritePoolSize=500" />
Integrated Security=SSPI" />
<add name="defRepositoryUri" connectionString="" />
<add name="defWorkingCopyPath" connectionString="%TEMP%\%WORKSPACE%" />
<add name="defPackagesWorkingCopyPath"
connectionString="%TEMP%\%APPLICATION%\%WORKSPACE%\TerrasoftPackages" />
<add name="clientUnitContentPath"
connectionString="%TEMP%\%APPLICATION%\%WORKSPACE%\ClientUnitSrc" />
<add name="sourceControlAuthPath"
connectionString="%TEMP%\%APPLICATION%\%WORKSPACE%\Svn" />
<add name="elasticsearchCredentials" connectionString="User=[The ElasticSearch user name]; Password=[The ElasticSearch user password];" />
</connectionStrings>
You can see the database server name (Data Source) in the authorization window while connecting to the server using Microsoft SQL Server Management Studio (Fig. 1).
Fig. 1 SQL server authorization window
The (Initial Catalog) database name should match the [Database] field value that you specified when restoring database (Fig. 2).
The Integrated Security authentication based on the SPPI interface) is used by default to connect Creatio to the database server. To ensure successful connection to the database, it is necessary to specify the Windows user under which the connection to the database server will be performed.
If you want to log in to the MS SQL server with the user's login and password, you need to modify the ConnectionStrings.config file located in the Creatio site root folder. Replace the Integrated Security=SSPI variable with the UserID and Password variables in the database connection string (add name=”db”):
<add name="db" connectionString="Data Source=TSW\MSSQL2014;
Initial Catalog=7.10.2.1416_SalesEnterprise_Demo;
Persist Security Info=True; MultipleActiveResultSets=True;
User ID=Sup; Password=password; Pooling = true; Max Pool Size = 100; Async = true" />
In the case of using the login and password, it is also necessary to create a login and password for corresponding user on the MS SQL server.
