Move the database connection string in the web.config file

By default, Sitefinity CMS stores the connection string to the database in the DataConfig.config file, located in folder ~/App_Data/Sitefinity/Configuration/. You can move the connection string to the web.config file, if this is required.

To do this, perform the following:

1. Open the DataConfig.config file and copy and delete the <connectionStrings> section, which contains the connection string.
2. Save and close the DataConfig.config file.
3. Open your web.config file and paste the copied section inside section <configuration>, after the </configSections> tag.
4. Delete the dbType attribute, because it is not supported in the web.config.
5. Add a parameter Backend inside the connection string.
6. Save and close the web.config file.

EXAMPLE: The following are examples of connection strings:

• Connection string section in the DataConfig.config:
  XML

  <connectionStrings>
         <add connectionString="data source=ABC;Integrated Security=SSPI;initial catalog=xyz"      providerName="System.Data.SqlClient" dbType="MsSql" name="Sitefinity" />
  </connectionStrings>

• Connection string section in the web.config:
  XML

  <connectionStrings> <add connectionString="data source=ABC;Integrated Security=SSPI;initial catalog=xyz;Backend=mssql"      providerName="System.Data.SqlClient" name="Sitefinity" />
  </connectionStrings>

NOTE: If you have connection strings with the same name in the DataConfig.config and in the web.config files, the one in the DataConfig.config file will be ignored.