asked on

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

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

ASKER CERTIFIED SOLUTION

aissim

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

badabing1

ASKER

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

aissim

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.

badabing1

ASKER

ok, thanks i will try this and let you know.

Thanks

badabing1

ASKER

dindnt work...