Microsoft KB Archive/921477

= Known problems when you upgrade to Windows Software Update Services (WSUS) Service Pack 1 =

Article ID: 921477

Article Last Modified on 6/21/2007

-

APPLIES TO


 * Microsoft Software Update Services 1.0

-



Important This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows registry





INTRODUCTION
This article discusses some of the known problems that may occur when you upgrade to Microsoft Windows Software Update Services (WSUS) Service Pack 1 (SP1).



Proxy server user name and password settings are reset
If you are using a proxy server, upgrading to WSUS SP1 may reset the proxy server user name and password settings. When this occurs, you receive the following error message when you try to synchronize the updates from the Microsoft servers:

Invalid parameter

To resolve this problem, reset the proxy server user name and password, and then re-synchronize the server. To do this, follow these steps:
 * 1) Start Internet Explorer.
 * 2) On the Tools menu, click Internet Options.
 * 3) On the Connections tab, click LAN Settings.
 * 4) Under Proxy server, clear the Address, Port, and Use a proxy server for your LAN check boxes.
 * 5) Click OK two times.

WSUS SP1 does not update WSUS servers that are set up using remote SQL deployments
To resolve this problem, WSUS SP1 must be installed on both the front end server and the back end server. First, install WSUS SP1 by using the upgrade option on the front end server without using switches. Then, do the same on the back end server.

Computer name changes after you install the original release version of WSUS and before you install WSUS SP1
To work around this problem, use the following script to remove and then replace the ASPNET and WSUS Administrators groups. Then, run the upgrade option again.

Note In the last line of this script, replace  with the path of the actual content store. osql.exe -S %computername%\WSUS -E -Q &quot;USE SUSDB DECLARE @asplogin varchar(200) SELECT @asplogin=name from sysusers WHERE name like '%ASPNET' EXEC sp_revokedbaccess @asplogin&quot; osql.exe -S %computername%\WSUS -E -Q &quot;USE SUSDB DECLARE @wsusadminslogin varchar(200) SELECT @wsusadminslogin=name from sysusers WHERE name like '%WSUS Administrators' EXEC sp_revokedbaccess @wsusadminslogin&quot;

osql.exe -S %computername%\WSUS -E -Q &quot;USE SUSDB DECLARE @asplogin varchar(200) SELECT @asplogin=HOST_NAME+'\ASPNET' EXEC sp_grantlogin @asplogin EXEC sp_grantdbaccess @asplogin EXEC sp_addrolemember webService,@asplogin&quot; osql.exe -S %computername%\WSUS -E -Q &quot;USE SUSDB DECLARE @wsusadminslogin varchar(200) SELECT @wsusadminslogin=HOST_NAME+'\WSUS Administrators' EXEC sp_grantlogin @wsusadminslogin EXEC sp_grantdbaccess @wsusadminslogin EXEC sp_addrolemember webService, @wsusadminslogin&quot;

osql.exe -S %computername%\WSUS -E -Q &quot;backup database SUSDB to disk=N'\SUSDB.Dat' with init&quot;

WSUS SP1 upgrade may fail when the Microsoft SQL Server 2000 Desktop Engine (Windows) (MSDE) database has been migrated to a local SQL Server 2000 computer
Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

If this problem occurs, you must change the value for the  registry subkey from 1 to 0. To do this, follow these steps:  Click Start, click Run, type regedit, and then click OK. Locate and then click the following registry subkey:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Update Services\Server\Setup

 In the right pane, right-click WmsdeInstalled, and then click Modify. In the Value data box, type 0, and then click OK. Exit Registry Editor. Upgrade to WSUS SP1.</li></ol>

WSUS SP1 upgrade may fail when the MSDE database has been migrated to a remote SQL Server 2000 computer
Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

If this problem occurs, you must change the values of the following registry subkeys:
 * You must change the value of the  subkey from 1 to 0.
 * You must change the value of the  subkey from 0x80 to 0x20.

To do this, follow these steps: <ol> Click Start, click Run, type regedit, and then click OK.</li> Locate and then click the following registry subkey:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Update Services\Server\Setup

</li> In the right pane, right-click WmsdeInstalled, and then click Modify.</li> In the Value data box, type 0, and then click OK.</li> Locate and then click the following registry subkey:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Update Services\Server\Setup

</li> In the right pane, right-click InstallType, and then click Modify.</li> In the Value data box, type 0x20, and then click OK.</li> Exit Registry Editor.</li> Upgrade to WSUS SP1 on the back end server.</li> Upgrade to WSUS SP1 on the front end server.</li></ol>

WSUS database is in an inconsistent state after a failed upgrade
If the upgrade to WSUS SP1 fails, the WSUS database may be in an inconsistent and unusable state. To retry the upgrade, you can use the original WSUS backup database that was created at the start of the upgrade process to restore the WSUS database to a consistent state. To do this, follow these steps: <ol> Determine the location of the backup database. To do this, review the contents of the %SystemRoot%\Program Files\Update Services\LogFilesWSUSSetup_%timestamp%.log file.</li>  Restore the backup database on the computer that is running WSUS. To do this, run the following script.

Note Replace  with the location of the backup database that you determined in step 1. Then, replace  with the value from the   registry subkey. osql.exe -S <DatabaseInstance> -E -Q &quot;USE master ALTER DATABASE SUSDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE RESTORE DATABASE SUSDB FROM DISK=N'<PathToDatabaseBackup>' WITH REPLACE ALTER DATABASE SUSDB SET MULTI_USER&quot; </li> Uninstall WSUS and keep the WSUS database, log files, and update files when you are prompted to remove them. Make sure that all the check boxes on the Remove Microsoft Windows Server Update Services screen are unchecked.</li> Reinstall the original release version of WSUS to return the WSUS database to a consistent state. Use the existing database when you are prompted for the database.

Note You cannot use the database that you backed up in step 1 in a clean install of WSUS SP1 because the database schema in the original release version of WSUS differs from the schema in WSUS SP1.</li> Install WSUS SP1.</li></ol>

Keywords: kbmsccsearch kbtshoot kbpubtypekc kbinfo KB921477

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.