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 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.
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