Windows Internal Database - MSSQL$MICROSOFT##SSEE

Not what has caused the problem but my WSUS always worked fine but does not want to connect to the server. After some research I have found that the Windows Internal Database is not starting up. What can I do to fix this problem as non of my clients are getting there updates currently.

I have attached the snap shot of the error which I get when trying to start the Windows Internal Database service.
GGassonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Shreedhar EtteCommented:
Where is the snap shot?
0
GGassonAuthor Commented:
Sorry, here it is.
WSUS.png
0
Shreedhar EtteCommented:
Hi,

Change the Service Logon as to Local System and then Start the services.

I hope this helps,
Shree
0
GGassonAuthor Commented:
Hi,

I have changed the account and started the services and this time with no error. But when I try and run WSUS I get the following error still. (Please see attached.)
WSUS1.png
0
DonNetwork AdministratorCommented:
WID(Windows internal Database) should be running under Network Service as it was. The database is probably corrupt.
 
You are most likely gonna have to uninstall/reinstall  WSUS and manually remove WID.

http://www.computersplace.com/how-to-uninstall-wsus-30-after-you-have-removedfucked-up-the-database-manually/msi 
 
This is a more thorough removal in case you have trouble reinstalling WSUS.
http://blogs.technet.com/sus/archive/2008/11/05/how-to-manually-remove-all-of-wsus.aspx
In addition to the blog above, the following will need to be run to remove WID
On 32-bit platforms: msiexec /x {CEB5780F-1A70-44A9-850F-DE6C4F6AA8FB} callerid=ocsetup.exe
On 64-bit platforms: msiexec /x {BDD79957-5801-4A2D-B09E-852E7FA64D01} callerid=ocsetup.exe

 
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.