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:

  • Connection string section in the web.config:
     

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.

Increase your Sitefinity skills by signing up for our free trainings. Get Sitefinity-certified at Progress Education Community to boost your credentials.

Web Security for Sitefinity Administrators

The free standalone Web Security lesson teaches administrators how to protect your websites and Sitefinity instance from external threats. Learn to configure HTTPS, SSL, allow lists for trusted sites, and cookie security, among others.

Foundations of Sitefinity ASP.NET Core Development

The free on-demand video course teaches developers how to use Sitefinity .NET Core and leverage its decoupled architecture and new way of coding against the platform.

Was this article helpful?