Sales Creatio, commerce edition
PDF
This documentation is valid for Creatio version 7.16.0. We recommend using the newest version of Creatio documentation.

Setting up the ConnectionStrings.config for the MS SQL Server

To set up the ConnectionStrings.config file:

1.Go to the root directory of the Creatio application ~\WebAppRoot\Creatio.

2.Open the ConnectionStrings.config file in a text editor.

3.Specify the connection parameters (connectionStrings):

a.For the restored database (name=”db”).

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

scr_setup_server_name.png 

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.

<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" />

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" />

b.For Redis Server (name=”redis”):

<add name="redis" connectionString="host=[Computer name];db=[Redis DB number];port=6379;
maxReadPoolSize=10;maxWritePoolSize=500" />

Note

Starting with Creatio version 7.13.4, you can set up a password-protected connection with Redis. To do this, specify the password when setting up the ConnectionStrings.config file:

<add name="redis" connectionString="host=[Computer name];db=[Redis DB number];port=6379;password=xxx;maxReadPoolSize=10;maxWritePoolSize=500" />

A sample ConnectionStrings.config file.

<?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>

See also

Checking Windows mandatory components

Configure the application site on IIS.

Set up websockets.

Switching from HTTP to HTTPS

Did you find this information useful?

How can we improve it?