Share via

Upgrade a Stand-Alone Installation Running SQL Server

  • Article

During the upgrade process, you uninstall all non-Windows applications—including SQL Server—and then reinstall them after the upgrade.

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.

Upgrading UDDI Services

To upgrade UDDI Services when you are running SQL Server

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

  2. Install an appropriate edition of SQL Server 2005.

  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 window, run the Universal Description, Discovery, and Integration (UDDI) upgrade tool by typing the appropriate command in the following list, depending on your system configuration.

Command, with example Configuration and instructions

uddiupgrade.exe

SQL Server is the default database instance on the computer. UDDI Services was installed in the default location in Windows Server 2003 (%systemdrive%\inetpub\uddi). At a command prompt, type the command, and then press ENTER.

uddiupgrade.exe /sqlsvr:UDDISVR\UDDI

SQL Server is not the default database instance on the computer. Type the command, and enter the instance name. For example, if the local computer name is UDDISVR and the SQL Server instance name is UDDI, type the command as in the example, and then press ENTER.

uddiupgrade.exe /dbfile:d:\uddi\data\uddi.sys.mdf

Under the Windows Server 2003 operating system, UDDI Services was not installed in the default location (%systemdrive%\inetpub\uddi). Type the command, and then enter the full path of the database file uddi.sys.mdf, which is typically located in the \data folder under the UDDI Services installation folder. For example, if UDDI Services was installed at d:\uddi under Windows Server 2003, type the command as in the example, and then press ENTER.

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.