Go Back   TechArena Community > Technical Support > Computer Help > Windows Server > Server Update Service
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



WSUS cannot connect to database

Server Update Service


Reply
 
Thread Tools Search this Thread
  #1  
Old 16-02-2007
Member
 
Join Date: Sep 2004
Posts: 59
WSUS cannot connect to database

I was using WSUS on Windows 2000 SP4 server using MSDE database but now i have built 2003 SP1 server which uses SQL 2000. I have installed all required hacks ans fixes so that SQL version/patch level matches my previous MSDE installation.msdb databases have been restored in new SQL installation and WSUS has created the SUSDB database within SQL as well but now when i am trying to access WSUS admin page then i am getting an message saying "Error connecting to the Windows Server Update Services database". I have gone through event log and i see this:

Connection to database failed. Reason=Cannot open database requested in
login 'SUSDB'. Login fails.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.. Connection string:

I want to know if i can do anything to to get back access to WSUS admin page?

Reply With Quote
  #2  
Old 16-02-2007
Member
 
Join Date: Jun 2009
Posts: 4,105
I will like to inform you that database "user" account is associated with SID, to the SQL Login because of which when database is restored to another server, SIDs gets changed. Anyways you can go through below article for understanding system stored procedures and for sorting out the issue you are facing.
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Windows Server > Server Update Service
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "WSUS cannot connect to database"
Thread Thread Starter Forum Replies Last Post
Database Size and Requirement for WSUS 3.0 Ascetica Server Update Service 5 20-04-2010 08:21 PM
How to move wsus 3.0 database MikeY007 Server Update Service 3 25-10-2008 12:29 AM
moving wsus 3.0 int. database to a new hard disk Christopher Server Update Service 4 30-10-2007 02:15 AM
WSUS client unable to connect WSUS server BoanHed Server Update Service 3 28-10-2007 03:29 AM
can't uninstall WSUS - Windows internal database problems.. 2muchreality Server Update Service 4 17-08-2007 01:34 PM


All times are GMT +5.5. The time now is 02:31 AM.