Share via

Upgrade a Distributed Installation Running a SQL Server Failover Cluster

  • Article

In an upgrade of a distributed installation of UDDI Services, upgrade the UDDI Services Database first, and then upgrade the UDDI Services Web Application server.

Upgrading the UDDI Services Database on a SQL Server failover cluster

Membership in Administrators, or equivalent, is the minimum required to complete the upgrade. Review details about using the appropriate accounts and group memberships at https://go.microsoft.com/fwlink/?LinkId=83477.

To upgrade the UDDI Services database

  1. Upgrade the SQL Server 2000 or SQL Server 2005 failover cluster on Windows Server 2003 to SQL Server 2005 failover on Windows Server 2008 according to procedures and best practices for SQL Server.

  2. Log on to the active node of the failover cluster.

  3. Click Start, right-click Command Prompt, and then click Run as administrator.

  4. If the User Account Control dialog box appears, confirm that the action it displays is what you want, and then click Continue.

  5. At the command prompt, run the Universal Description, Discovery, and Integration (UDDI) upgrade tool by typing the appropriate command in the following table, depending on your system configuration.

Command, with example Instructions

Uddiupgrade.exe /sqlsvr:UDDISVR\UDDI /dbfile:d:\uddi\data\uddi.sys.mdf

Type the command, enter the virtual server name and clustered SQL instance name, and then enter the full path of the database file uddi.sys.mdf, which is located on the shared drive of the failover cluster. For example, if the virtual server name is UDDISVR, the clustered SQL instance name is UDDI, and the UDDI Services Database file is d:\uddi\data\uddi.sys.mdf under Windows Server 2003, type the command as in the example, and then press ENTER.

Upgrading the UDDI Services Web Application server

Membership in Administrators, or equivalent, on the local Web server and on the remote UDDI Services Database Server is required to complete this procedure. Review details about using the appropriate accounts and group memberships at https://go.microsoft.com/fwlink/?LinkId=83477.

To upgrade the computer that is the UDDI Services Web Application server

  1. Upgrade the Windows Server 2003 operating system to the corresponding edition of Windows Server 2008.

  2. Click Start, right-click Command Prompt, and then click Run as administrator.

  3. If the User Account Control dialog box appears, confirm that the action it displays is what you want, and then click Continue.

  4. At the command prompt, type the following command, and then press ENTER:

    uddiupgrade.exe

To view the complete syntax for this command, and for information about entering user account information, at a command prompt, type the following command, and then press ENTER:

uddiupgrade.exe /?

Additional considerations

To open an elevated Command Prompt window, click Start, point to All Programs, click Accessories, right-click Command Prompt, and then click Run as administrator.