Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Cannot Start WSUS service and cannot login to windows update WSUSADmin page!

Posted on 2008-09-29
6
Medium Priority
?
1,165 Views
Last Modified: 2012-05-05
Hi,

I think this issue is caused becuase my MSDE200 database file for WSUS has grown above 2.12GB and the limit to Msde2000 is 2GB correct?

how do i get around this as i can't start wsus instance in Sql enterprise Manager, i cant start MSQL$WSUS service, it starts for 5 seconds and then stops. All was working ok, and im pretty sure this is due to database size limit.

this is the error and nothing has changed in relation to user accounts etc..

Connection to database failed. Reason=Cannot open database requested in login 'SUSDB'. Login fails.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.. Connection string: Data Source=server\WSUS;Initial Catalog=SUSDB;Connection Timeout=60;Application Name=WSUS SQL Connection;Trusted_Connection=Yes;Pooling='true'; Max Pool Size = 100

your help is greatly appreciated!

Thanks
0
Comment
Question by:badabing1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 19

Accepted Solution

by:
aissim earned 2000 total points
ID: 22607424
I would start by trying the wsusutil.exe. First stop the WWW publishing service, then run:

wsusutil deleteunneededrevisions


This should delete unneeded revisions, and their history, from the database.
0
 

Author Comment

by:badabing1
ID: 22648744
so doing this will fix the problem, also do you think the problem is caused by the size of database, if so then this is really poor design by microsoft, which doesnt alert or inform you about this limititaion!!!

Thanks
0
 
LVL 19

Expert Comment

by:aissim
ID: 22655317
Definitely think the problem is the size of your DB - hopefully the command above will shrink it enough for services to start. If that does not work, I know many people deal with this issue by upgrading to a full sql server installation (or 2005 SqlExpress) which eliminates the size restriction.

And I agree with you - MS does have the size limit documented, but don't do a good job of warning you about it.
0
 

Author Comment

by:badabing1
ID: 22659013
ok, thanks i will try this and let you know.

Thanks
0
 

Author Comment

by:badabing1
ID: 22749626
dindnt work...
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question