BELRpR
asked on
WSUS installation on Sql server
Hi,
I am installing wsus on a windows 2003 x 64 server called server02
I also have a server01 which runs mssql 2008 standard.
When I install wsus everything goes fine. When I put server02 as remote db server it says ok.
A few seconds after the installation wizard closes the follow popup occurs.
"An error occurred when trying to preform a database operation, and the wizard must be closed. You may restart the WSUS Server Configuration Wizard from the Options page in the WSUS 3.0 console." See Attachement A
I then launch the WSUS management console, and it is not connected to the server (NEO), so I click on connect to server, type NEO in the server block and use the drop down to select port specified during the installation. When I click ok I get the following error.
'Cannot connect to 'server02'. SQL server may not be running on the server.
Here are the step I have taken to try and resolve the problem Unsuccessfully
Registered SPN for the SQL instance - http://support.microsoft.com/kb/909801
The best I've tried.
I also found this:
https://www.experts-exchange.com/questions/23845370/WSUS-installation-fail-when-connecting-to-Remote-SQL-2005-Server.html
It is exactly my problem but I ain't so advanced user so the solution seems complicated.
Here are a couple of items from the event logs:
~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 10/24/2008
Time: 11:55:48 AM
User: NT AUTHORITY\ANONYMOUS LOGON
Computer: server01
Description:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 192.168.101.204]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00 .H......
0008: 07 00 00 00 4f 00 52 00 ....O.R.
0010: 41 00 43 00 4c 00 45 00 A.C.L.E.
0018: 00 00 07 00 00 00 6d 00 ......m.
0020: 61 00 73 00 74 00 65 00 a.s.t.e.
0028: 72 00 00 00 r...
~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~
Event Type: Warning
Event Source: Windows Server Update Services
Event Category: None
Event ID: 7042
Date: 10/24/2008
Time: 11:32:02 AM
User: N/A
Computer: server02
Description:
The WSUS administration console was unable to connect to the WSUS Server Database.
Verify that SQL server is running on the WSUS Server. If the problem persists, try restarting SQL.
System.Data.SqlClient.SqlE xception -- Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Source
.Net SqlClient Data Provider
Stack Trace:
at Microsoft.UpdateServices.I nternal.Ba seApi.Soap ExceptionP rocessor.D eserialize AndThrow(S oapExcepti on soapException)
at Microsoft.UpdateServices.I nternal.Da tabaseAcce ss.AdminDa taAccessPr oxy.Execut eSPGetTarg etGroupByI d(Guid id)
at Microsoft.UpdateServices.I nternal.Ba seApi.Comp uterTarget Group.GetB yId(Guid id, UpdateServer updateServer)
at Microsoft.UpdateServices.I nternal.Ba seApi.Upda teServer.G etComputer TargetGrou p(Guid id)
at Microsoft.UpdateServices.U I.AdminApi Access.Adm inApiTools .TestSqlCo nnection(I UpdateServ er server)
at Microsoft.UpdateServices.U I.AdminApi Access.Adm inApiTools .GetUpdate Server()
at Microsoft.UpdateServices.U I.SnapIn.W izards.OOB E.OOBEWiza rd.get_Adm inApiTools ()
at Microsoft.UpdateServices.U I.SnapIn.W izards.OOB E.OOBEWiza rd.get_Ser verState()
at Microsoft.UpdateServices.U I.SnapIn.W izards.OOB E.OOBEWiza rd.SetNavi gationItem EnabledSta tes()
at Microsoft.UpdateServices.U I.SnapIn.W izards.OOB E.OOBEWiza rd.Initial izeNavigat ionItems()
at Microsoft.UpdateServices.U I.SnapIn.W izards.OOB E.OOBEWiza rd.OOBEWiz ardInitial ize()
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
I am installing wsus on a windows 2003 x 64 server called server02
I also have a server01 which runs mssql 2008 standard.
When I install wsus everything goes fine. When I put server02 as remote db server it says ok.
A few seconds after the installation wizard closes the follow popup occurs.
"An error occurred when trying to preform a database operation, and the wizard must be closed. You may restart the WSUS Server Configuration Wizard from the Options page in the WSUS 3.0 console." See Attachement A
I then launch the WSUS management console, and it is not connected to the server (NEO), so I click on connect to server, type NEO in the server block and use the drop down to select port specified during the installation. When I click ok I get the following error.
'Cannot connect to 'server02'. SQL server may not be running on the server.
Here are the step I have taken to try and resolve the problem Unsuccessfully
Registered SPN for the SQL instance - http://support.microsoft.com/kb/909801
The best I've tried.
I also found this:
https://www.experts-exchange.com/questions/23845370/WSUS-installation-fail-when-connecting-to-Remote-SQL-2005-Server.html
It is exactly my problem but I ain't so advanced user so the solution seems complicated.
Here are a couple of items from the event logs:
~~~~~~~~~~~~~~~~~~~~~~~~~~
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 10/24/2008
Time: 11:55:48 AM
User: NT AUTHORITY\ANONYMOUS LOGON
Computer: server01
Description:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 192.168.101.204]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00 .H......
0008: 07 00 00 00 4f 00 52 00 ....O.R.
0010: 41 00 43 00 4c 00 45 00 A.C.L.E.
0018: 00 00 07 00 00 00 6d 00 ......m.
0020: 61 00 73 00 74 00 65 00 a.s.t.e.
0028: 72 00 00 00 r...
~~~~~~~~~~~~~~~~~~~~~~~~~~
Event Type: Warning
Event Source: Windows Server Update Services
Event Category: None
Event ID: 7042
Date: 10/24/2008
Time: 11:32:02 AM
User: N/A
Computer: server02
Description:
The WSUS administration console was unable to connect to the WSUS Server Database.
Verify that SQL server is running on the WSUS Server. If the problem persists, try restarting SQL.
System.Data.SqlClient.SqlE
Source
.Net SqlClient Data Provider
Stack Trace:
at Microsoft.UpdateServices.I
at Microsoft.UpdateServices.I
at Microsoft.UpdateServices.I
at Microsoft.UpdateServices.I
at Microsoft.UpdateServices.U
at Microsoft.UpdateServices.U
at Microsoft.UpdateServices.U
at Microsoft.UpdateServices.U
at Microsoft.UpdateServices.U
at Microsoft.UpdateServices.U
at Microsoft.UpdateServices.U
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.