Q. You receive 'Error 0x80070643: Fatal error during installation' during WSUS (Windows Server Update Services) setup?

During WSUS Setup, you receive an error similar to:

Error 0x80070643: Fatal error during installation..

The Wsusca.txt file records information that is similar to:

The Commit phase completed successfully. ***** 2005-09-12 13:06:18 17:06:18 Executing External Command: C:Program FilesUpdate Services\toolsosqlosql.exe -S WINSECSUSPARENTWSUS -E -b -n -Q "USE SUSDB EXEC sp_grantlogin N'NT AUTHORITYNETWORK SERVICE' EXEC sp_grantdbaccess N'NT AUTHORITYNETWORK SERVICE' EXEC sp_addrolemember webService,N'NT AUTHORITYNETWORK SERVICE'" ***** Msg 15247, Level 16, State 1, Server WINSECSUSPARENTWSUS, Procedure sp_grantlogin,                  Line 12 User does not have permission to perform this action.                 Granted database access to 'NT AUTHORITYNETWORK SERVICE'.                 'NT AUTHORITYNETWORK SERVICE' added to role 'webService'.***** 2005-09-12 13:06:18 17:06:18 External Command Exited, Return Code: 1 ***** ***** 2005-09-12 13:06:18 17:06:18 Executing External Command:C:Program FilesUpdate Services\toolsosqlosql.exe -S WINSECSUSPARENTWSUS -E -b -n -Q "USE SUSDB EXEC sp_revokedbaccess N'NT AUTHORITYNETWORK SERVICE'" ***** User has been dropped from current database. ***** 2005-09-12 13:06:18 17:06:18 External Command Exited, Return Code: 0 ***** ***** 2005-09-12 13:06:18 17:06:18 Executing External Command: C:Program FilesUpdate Services\toolsosqlosql.exe -S WINSECSUSPARENTWSUS -E -b -n -Q "USE SUSDB EXEC sp_revokedbaccess N'WINSECSUSPARENTASPNET'" ***** Msg 15008, Level 16, State 1, Server WINSECSUSPARENTWSUS, Procedure sp_revokedbaccess,                  Line 36 User 'WINSECSUSPARENTASPNET' does not exist in the current database. ***** 2005-09-12 13:06:18 17:06:18 External Command Exited, Return Code: 1 ***** ***** 2005-09-12 13:06:18 17:06:18 Executing External Command: C:Program FilesUpdate Services\toolsosqlosql.exe -S WINSECSUSPARENTWSUS -E -b -n -Q "USE SUSDB EXEC sp_revokedbaccess N'WINSECSUSPARENTWSUS Administrators'" ***** Msg 15008, Level 16, State 1, Server WINSECSUSPARENTWSUS, Procedure sp_revokedbaccess,                 Line 36 User 'WINSECSUSPARENTWSUS Administrators' does not exist in the current database. ***** 2005-09-12 13:06:18 17:06:18 External Command Exited, Return Code: 1 ***** ***** 2005-09-12 13:06:18 17:06:18 Executing External Command: C:Program FilesUpdate Services\toolsosqlosql.exe -S WINSECSUSPARENTWSUS -E -b -n -Q "EXEC sp_revokelogin N'WINSECSUSPARENTWSUS Administrators'" ***** Msg 15247, Level 16, State 1, Server WINSECSUSPARENTWSUS, Procedure sp_revokelogin,                  Line 12 User does not have permission to perform this action. ***** 2005-09-12 13:06:18 17:06:18 External Command Exited, Return Code: 1 ***** The uninstall is beginning.

WSUS Setup uses Microsoft SQL Server to perform the installation, which requires that the user running WSUS setup have administrative authority.

To grant administrative authority to a new user account or new group":

1. Save the following text in Notepad as GrantAdmin.sql:

EXEC sp_grantlogin ''GoEXEC sp_addsrvrolemember '', 'sysadmin'Go

NOTE: For an existing user or group, use:

EXEC sp_addsrvrolemember '', 'sysadmin'Go

2. Open a CMD.EXE window.

3. Type the following command and press Enter:

osql -E -i C:GrantAdmin.sql