Change IIS web configuration file

Owned by Glen Epperson (Unlicensed)
Last updated: Nov 03, 2017 by Conor McCann
1 min read

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  

Filter by label

There are no items with the selected labels at this time.