- Decrypt the Web Configuration Information
- Decrypt the Web Configuration Information
- "81185dd2-4612-4a71-92b8-91bb27a6beb7
- During the upgrade process, you will be required to re-enter information about the previous installation. This information is located in the web.config file. Depending on the version you are upgrading from, it may be encrypted.
- To decrypt the configuration file contents, open a command prompt and use the Aspnet_regiis tool with the following parameters:
- -pd switch, for decryption, followed by the name of the configuration element to be decrypted enclosed in quotes; in this case "connectionStrings"
- -app switch, to identify the application (virtual directory), followed by the name of the application (virtual directory) enclosed in quotes
- -site switch, to identify the site number where the application (virtual directory) resides, followed by the site ID or identifier enclosed in quotes; see below for more information on finding the site identifier
- The following command decrypts the connectionStrings element in the Web.config file for the ASP.NET application (virtual directory) ODSContent. In the first example the application (virtual directory) is assumed to be from Web site 1 (most commonly the Default Web Site in IIS).
- C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis -pd "connectionStrings" -app "/<Virtualdirectory>" -site "<siteID or Indentifier>"
- Example using the Default Web Site:
- C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis -pd "connectionStrings" -app "/ODSContent" -site "1"
- Example when using a different Web Site:
- C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis -pd "connectionStrings" -app "/ODSContent" -site "4567890"
- Additional Reference:
- The Site ID or Identifier
- There are numerous ways to find this information, but the fastest way is through the Internet Information Services (IIS) Manager. In IIS6 the Site ID is also known as Identifier while in IIS 7 it is also known as ID.
- Open Internet Information Services (IIS) Manager.
- Click <machinename> (local computer).
- Click Web Sites (IIS6) or Sites (IIS 7).
- Locate the Connection String Information
- Open the web.config file in any text editor. Locate the <connectionStrings> element. Within this element you see an <add> element which contains three attributes: "add", "connectionString" and "providerName". You need the "connectionString" attribute, which varies depending on whether you are using an Oracle Database server or a Microsoft SQL server.
- Oracle Database server
- Data Source=<hoststring>; User Id=<schema_user>; Password=<password>
- Example:
- Data Source=orcl; User Id=ODServer_app; Password=mypassword;
- Note:
- Microsoft SQL Server
- user id=<login id>; password=<password>;integrated security=false;data source=<server>;initial catalog="<database name>"
- Example:
- user id=ODServer; password=mypassword;integrated security=false;data source=(local);initial catalog="ODDevContent";