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.

Want to learn more?

Sign up for our free beginner training. Boost your credentials through advanced courses and certification.
Register for Sitefinity training and certification.

Was this article helpful?