Change IIS web configuration file

Problem

Changing the web.config connection string which supports the CMS DB. And encrypt the password again.

Solution

• Edit the %IQSonarInstallation%\Sonar\web.conf file.

• Change the connectionString tag to point to your new installation.

Typically this <connectionStrings> area is encrypted and you will need to replace several dozen lines with this:

  <connectionStrings>

<add name="databaseConnection" connectionString="factory=System.Data.SqlClient;server=SERVER\INSTANCE;database=CMS-DATABASE-NAME;Uid=USERNAME;password=PASSWORD;" />

  </connectionStrings>

UPdate these fields to the appropraite values:

• SERVER\INSTANCE
• CMS-DATABASE-NAME
• USERNAME
• PASSWORD

• Save the file.
• Test the connction.
• Encrypt the clear text password

The ASP Net has a built in tool to encrypt various parts of the file.

The Aspnet_regiis.exe tool is located in the %windows%\Microsoft.NET\Framework\versionNumber folder.

A Default installation of iQSonar would use this command to encrypt the string:

aspnet_regiis -pe "connectionStrings" -app "/iQSonar"

•  Test the connection again.

Additional Notes

Additional Details for aspnet_regiss can be found at:

https://msdn.microsoft.com/en-us/library/zhhddkxy(v=vs.140).aspx  

Related articles