Q. You receive 'Error 0x80070643: Fatal error during installation' during WSUS (Windows Server Update Services) setup?
Jerold Schulman
July 23, 2006
2 Min Read
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
About the Author
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
You May Also Like