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:

<font size="1"><b>The Commit phase completed successfully.
***** 2005-09-12 13:06:18 17:06:18 Executing External Command:
C:\Program Files\Update Services\\tools\osql\osql.exe -S WINSECSUSPARENT\WSUS -E -b -n -Q
"USE SUSDB EXEC sp_grantlogin N'NT AUTHORITY\NETWORK SERVICE' EXEC
sp_grantdbaccess N'NT AUTHORITY\NETWORK SERVICE' EXEC
sp_addrolemember webService,N'NT AUTHORITY\NETWORK SERVICE'"
***** Msg 15247, Level 16, State 1, Server WINSECSUSPARENT\WSUS, Procedure sp_grantlogin,
                 Line 12 User does not have permission to perform this action.
                 Granted database access to 'NT AUTHORITY\NETWORK SERVICE'.
                 'NT AUTHORITY\NETWORK 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 Files\Update Services\\tools\osql\osql.exe -S WINSECSUSPARENT\WSUS -E -b -n -Q
"USE SUSDB EXEC sp_revokedbaccess N'NT AUTHORITY\NETWORK 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 Files\Update Services\\tools\osql\osql.exe -S WINSECSUSPARENT\WSUS -E -b -n -Q
"USE SUSDB EXEC sp_revokedbaccess N'WINSECSUSPARENT\ASPNET'"
***** Msg 15008, Level 16, State 1, Server WINSECSUSPARENT\WSUS, Procedure sp_revokedbaccess,
                 Line 36 User 'WINSECSUSPARENT\ASPNET' 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 Files\Update Services\\tools\osql\osql.exe -S WINSECSUSPARENT\WSUS -E -b -n -Q
"USE SUSDB EXEC sp_revokedbaccess N'WINSECSUSPARENT\WSUS Administrators'"
***** Msg 15008, Level 16, State 1, Server WINSECSUSPARENT\WSUS, Procedure sp_revokedbaccess,
                 Line 36 User 'WINSECSUSPARENT\WSUS 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 Files\Update Services\\tools\osql\osql.exe -S WINSECSUSPARENT\WSUS -E -b -n -Q
"EXEC sp_revokelogin N'WINSECSUSPARENT\WSUS Administrators'"
***** Msg 15247, Level 16, State 1, Server WINSECSUSPARENT\WSUS, 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.</b></font>
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 '<SQL_Server_Name>\<User_Logon_Name>'
Go
EXEC sp_addsrvrolemember '<SQL_Server_Name>\<User_Logon_Name>', 'sysadmin'
Go
NOTE: For an existing user or group, use:
EXEC sp_addsrvrolemember '<SQL_Server_Name>\<User_Logon_Name>', 'sysadmin'
Go
2. Open a CMD.EXE window.

3. Type the following command and press Enter:

osql -E -i C:\<FolderName>\GrantAdmin.sql