myITforum.com Community Forum myITforum.com Community Forum

Home  Forums  Blogs  Live Support chat  Search Articles  Wiki  FAQ  Email Lists  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

All Forums RSS Feed Subscription:


  


SCCM Using Remote WSUS which uses Remote DB

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> SCCM Using Remote WSUS which uses Remote DB Page: [1]
Login
Message << Older Topic   Newer Topic >>
SCCM Using Remote WSUS which uses Remote DB - 8/1/2008 5:12:37 PM   
Striker169

 

Posts: 19
Score: 0
Joined: 12/26/2006
Status: offline 		My current setup is that I have my SCCM box with pretty much everything installed on it except WSUS. My WSUS box is a VM on one of our vm hosts and it uses a remote database on our SQL Cluster.
 
Right now I am getting this error:
 
Failures were reported on WSUS Server "VMWSUS" while trying to make WSUS database connection with SQL Exception error code -2146232060.
Possible cause: SQL Database service is not running or cannot be accessed.
Solution: Verify that the SQL Server and SQL Server Agent services are running and can be contacted.
 
What settings/configuration do I need to change to tell my SCCM box that the WSUS database is not on the WSUS server but on a different SQL Database?
 
Or does anyone have any idea on why I am getting this error?
Post #: 1
RE: SCCM Using Remote WSUS which uses Remote DB - 8/1/2008 5:27:20 PM   
jsandys


Posts: 531
Score: 17
Joined: 3/24/2005
From: San Antonio, TX
Status: offline 		Nothing special.  Note that this message doesn't say that ConfigMgr cannot contact the DB, it says that WSUS cannot contact the DB.  What happens when you open the WSUS console on the WSUS server?  Does it connect?

_____________________________

Jason
________________________________________
http://myitforum.com/cs2/blogs/jsandys/default.aspx

(in reply to Striker169)
Post #: 2
RE: SCCM Using Remote WSUS which uses Remote DB - 8/1/2008 5:41:45 PM   
Striker169

 

Posts: 19
Score: 0
Joined: 12/26/2006
Status: offline 		Yeah, I have no problem looking though all the updates and approve or denying them in the console on both VMWsus or if I connect via our SCCM box. The thing is that this error keeps making my site status a red x, and obviously something is wrong...

< Message edited by Striker169 -- 8/1/2008 5:43:06 PM >

(in reply to jsandys)
Post #: 3
RE: SCCM Using Remote WSUS which uses Remote DB - 8/1/2008 5:53:19 PM   
jsandys


Posts: 531
Score: 17
Joined: 3/24/2005
From: San Antonio, TX
Status: offline 		What component is giving you the error?  Try restarting it using the ConfigMgr Service Manager and see it is continues to give you the error.

_____________________________

Jason
________________________________________
http://myitforum.com/cs2/blogs/jsandys/default.aspx

(in reply to Striker169)
Post #: 4
RE: SCCM Using Remote WSUS which uses Remote DB - 8/1/2008 6:10:19 PM   
Striker169

 

Posts: 19
Score: 0
Joined: 12/26/2006
Status: offline 		Its the SMS_WSUS_CONTROL_MANAGER

(in reply to jsandys)
Post #: 5
RE: SCCM Using Remote WSUS which uses Remote DB - 8/2/2008 11:53:56 AM   
jsandys


Posts: 531
Score: 17
Joined: 3/24/2005
From: San Antonio, TX
Status: offline 		Did the errors happen again when you restarted it?

_____________________________

Jason
________________________________________
http://myitforum.com/cs2/blogs/jsandys/default.aspx

(in reply to Striker169)
Post #: 6
RE: SCCM Using Remote WSUS which uses Remote DB - 8/4/2008 2:53:02 PM   
Striker169

 

Posts: 19
Score: 0
Joined: 12/26/2006
Status: offline 		Yes they did...

(in reply to jsandys)
Post #: 7
RE: SCCM Using Remote WSUS which uses Remote DB - 8/4/2008 3:16:48 PM   
jsandys


Posts: 531
Score: 17
Joined: 3/24/2005
From: San Antonio, TX
Status: offline 		What version of Windows Server is in use on each system?  Are there any firewalls software or hardware?  Is the SPN properly registered for the SQL Server?  Are you using ConfigMgr Native mode?

_____________________________

Jason
________________________________________
http://myitforum.com/cs2/blogs/jsandys/default.aspx

(in reply to Striker169)
Post #: 8
RE: SCCM Using Remote WSUS which uses Remote DB - 8/4/2008 4:27:09 PM   
Striker169

 

Posts: 19
Score: 0
Joined: 12/26/2006
Status: offline 		Both are Windows 2003 R2 Sp2. No firewalls. I belive the SPN is properly registered for the SQL Server I can double check that, and yes ConfigMgr is in Native Mode.

(in reply to jsandys)
Post #: 9
RE: SCCM Using Remote WSUS which uses Remote DB - 8/4/2008 5:09:07 PM   
jsandys


Posts: 531
Score: 17
Joined: 3/24/2005
From: San Antonio, TX
Status: offline 		Have you configured WSUS to use SSL (http://technet.microsoft.com/en-us/library/bb633246.aspx)?  Does WSUS use alternate ports; e.g., 8530 and 8531?  Are these configured in ConfigMgr (http://technet.microsoft.com/en-us/library/bb632477.aspx)?

_____________________________

Jason
________________________________________
http://myitforum.com/cs2/blogs/jsandys/default.aspx

(in reply to Striker169)
Post #: 10
RE: SCCM Using Remote WSUS which uses Remote DB - 8/4/2008 5:14:40 PM   
Striker169

 

Posts: 19
Score: 0
Joined: 12/26/2006
Status: offline 		WSUS is using SSL and so are all the clients here, WSUS does not use alternate ports, and the ports are set in ConfigMgr....

(in reply to jsandys)
Post #: 11
RE: SCCM Using Remote WSUS which uses Remote DB - 8/4/2008 5:47:51 PM   
jsandys


Posts: 531
Score: 17
Joined: 3/24/2005
From: San Antonio, TX
Status: offline 		Try removing the Software Update Point Role and re-adding it.  Does the FQDN specified for the site system match the certificate issued to the site server?

_____________________________

Jason
________________________________________
http://myitforum.com/cs2/blogs/jsandys/default.aspx

(in reply to Striker169)
Post #: 12
RE: SCCM Using Remote WSUS which uses Remote DB - 8/5/2008 11:08:16 AM   
Striker169

 

Posts: 19
Score: 0
Joined: 12/26/2006
Status: offline 		I tried it, still did not work... and what do you mean by the FQDN specified for the site system match the cert issued to the site server? I have an idea and I think so but I am not 100% sure what you are asking.

(in reply to jsandys)
Post #: 13
RE: SCCM Using Remote WSUS which uses Remote DB - 8/5/2008 11:55:06 AM   
jsandys


Posts: 531
Score: 17
Joined: 3/24/2005
From: San Antonio, TX
Status: offline 		The certificate issued to the WSUS server to enable SSL has a common name field that should contain the FQDN of the WSUS server.  Does this match the FQDN specified for the site server in ConfigMgr?  What system did you install the Software Update Point on?

_____________________________

Jason
________________________________________
http://myitforum.com/cs2/blogs/jsandys/default.aspx

(in reply to Striker169)
Post #: 14
RE: SCCM Using Remote WSUS which uses Remote DB - 8/5/2008 2:12:03 PM   
Striker169

 

Posts: 19
Score: 0
Joined: 12/26/2006
Status: offline 		The Software Update Point is installed on VMWSUS which is also our WSUS Server. The cert on our WSUS server that was issued to enable SSL is VMWSUS.xxxx.domainname.com and the FQDN that is listed on Site System for VMWSUS is VMWSUS.xxxx.domainname.com

Does that make sense?

< Message edited by Striker169 -- 8/5/2008 2:13:02 PM >

(in reply to jsandys)
Post #: 15
RE: SCCM Using Remote WSUS which uses Remote DB - 8/5/2008 2:56:38 PM   
jsandys


Posts: 531
Score: 17
Joined: 3/24/2005
From: San Antonio, TX
Status: offline 		Is your primary site server account a member of the local admins on VMWSUS? 

That's my last idea.  I've got ConfigMgr running for multiple customers in a similar configuration to what you've described without any issues so there must be something else that is being overlooked.  Without actually looking at everything myself, I don't think that there's anything else I can offer.

_____________________________

Jason
________________________________________
http://myitforum.com/cs2/blogs/jsandys/default.aspx

(in reply to Striker169)
Post #: 16
RE: SCCM Using Remote WSUS which uses Remote DB - 8/5/2008 5:55:08 PM   
Striker169

 

Posts: 19
Score: 0
Joined: 12/26/2006
Status: offline 		Question, when you setup WSUS, did you install it on your SQL Server using the /b switch? And when you did that does it show "Microsoft Windows Server Update Services 3.0 SP1" under the Administrator Tools under the start menu? And then in SCCM did you just set the front end server as your Update point or did you do anything to your SQL Server?

(in reply to jsandys)
Post #: 17
Page:   [1]
All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> SCCM Using Remote WSUS which uses Remote DB Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts



  
Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.266