WSUS Install Fix Posted - The Windows Server Essentials and Small Business Server Blog - Site Home

The SBS Documentation Team and Susan Bradley have posted the resolution to the "unable to install WSUS" issue on OEM installs of SBS 2003:

http://blogs.msdn.com/sbsdocsteam/archive/2005/08/24/455956.aspx

and

http://msmvps.com/bradley/archive/2005/08/24/63985.aspx

To confirm you are experiencing this issue, two conditions must be true:

1. You must have an OEM install. If you installed off of retail media and WSUS is not installing on your SBS for any reason, I want to hear from you, but the fix above probably isn't what is preventing WSUS from installing.

2. Look at your WSUSCA_xxxxxx_yyyy.log in the \Program files\Update Services\LogFiles of your install drive. Affected machines will show an error similar to the following :

osql.exe -S SERVERNAME\WSUS -E -b -n -Q "USE SUSDB EXEC sp_grantlogin N'DOMAIN\IWAM_OEM-MACHINE-NAME' EXEC sp_grantdbaccess N'DOMAIN\IWAM_OEM-MACHINE-NAME' EXEC sp_addrolemember webService,N'DOMAIN\IWAM_OEM-MACHINE-NAME'"

Msg 15401, Level 11, State 1, Server SERVERNAME\WSUS, Procedure sp_grantlogin, Line 41

Windows NT user or group 'DOMAIN\IWAM_OEM-MACHINE-NAME' not found. Check the name again.

Msg 15401, Level 11, State 1, Server SERVERNAME\WSUS, Procedure sp_grantdbaccess, Line 99

Windows NT user or group 'DOMAIN\IWAM_OEM-MACHINE-NAME'' not found. Check the name again.

Msg 15410, Level 11, State 1, Server SERVERNAME\WSUS, Procedure sp_addrolemember, Line 66

User or role 'DOMAIN\IWAM_OEM-MACHINE-NAME' does not exist in this database.

(Obviously, SERVERNAME, DOMAIN, and IWAM_OEM-MACHINE-NAME will be machine- and domain-specific).