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).

Generic syntax:
C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis -pd "connectionStrings" -app "/<Virtualdirectory>" -site "<siteID or Identifier>"

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:
http://msdn.microsoft.com/en-us/library/k6h9cz8h%28VS.80%29.aspx

The Site ID or Identifier
The Web site is identified using the site number from the Internet Information Services (IIS) metabase. You can retrieve the site number from the INSTANCE_META_PATH server variable in the ServerVariables collection. For example, when IIS is installed, a Web site named "Default Web Site" is created as site 1. In pages served from that site, the INSTANCE_META_PATH server variable returns "/LM/W3SVC/1".

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.

1. Open Internet Information Services (IIS) Manager.
    
2. Click <machinename> (local computer).
    
3. Click Web Sites (IIS6) or Sites (IIS 7).

Locate the Connection String Information 
Once you have decrypted the connection string information in the web.config file, you can locate the information you will need to answer the prompts during the upgrade process. In an installation that accepts all default values, the web.config file is located in "C:\Program Files\User Productivity Kit\UPK Developer 36Server\Repository.WS".

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
  The connection string is:
  Data Source=<hoststring>; User Id=<schema_user>; Password=<password>

Example:
Data Source=orcl; User Id=ODServer_app; Password=mypassword;
 
The Data Source contains the host string used during the previous installation. Enter this information in the Host String field on the Oracle Database Login screen.
 
The User ID contains the schema user name created during the previous installation. Remove the “_app” from the schema user name to get the schema owner name. Enter the schema owner information in the User Name field on the Choose Schema screen.
 
The Password contains the password for both the schema owner and schema user account. Enter this information in the Password field on the Choose Schema screen.
 
Note: It is very important that if you change the password for the schema user account, you also change the password for the schema owner account. The two passwords MUST always be the same.

• Microsoft SQL Server
  The connection string is:
  user id=<login id>; password=<password>;integrated security=false;data source=<server>;initial catalog=&quot;<database name>&quot;

Example:
user id=ODServer; password=mypassword;integrated security=false;data source=(local);initial catalog=&quot;ODDevContent&quot;; 
 
The user id contains the database login id information. Enter this information in the Login ID field on the Choose Database screen.
 
The password contains the password for the login id. Enter this information in the Password field on the Choose Database screen.
 
The data source contains the name of the database server used during the previous installation. Enter this information in the Database server field on the Microsoft SQL Server Login screen.
 
The initial catalog contains the name of the database used during the previous installation. Enter this information in the Database name field on the Choose Database screen.

Table of Contents  Back