We help IT Professionals succeed at work.

Lost Database Configuration for SQLSERVER, after WindowsServer2003 Update KB960715 ran overnight.

Medium Priority
1,212 Views
Last Modified: 2012-05-06
We can not log into our SQL SERVER after an update KB960715 for Microsoft Windows 2003 Server ran at 3:00am last evening.
Event 18456

THe MSSQL$MICROSOFT##SSEE can not be found.
Comment
Watch Question

Commented:
I had something very similar to this with another windows update. Took me a long while to figure out

Chances are what has happened is that the user that sharepoint uses possibly SYSTEM or NETWORK_SERVICE has had permissions removed from the directory in which the database resides. You need to search for the MDB files and re-add the user permissions to the folder and child objects.

I can';t be much more specific than that because many setups are different but it should give you a good starting place.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Ok, the Network Service did not have permissions to any folders or files.   I added the Network Services back to the folders and child object, but still am getting the same error.  When I look in the event viewer I am also getting an error that states I can not open database "STS_Config" requested by the login. Login Failed.

Author

Commented:
Wait, it did work, there was one more area where the STS_Config was located, that I need to bring down to the child object.  Once this was done, we were back in business.

Thank you very much!

Author

Commented:
Was extremely helpful!
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.