• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1187
  • Last Modified:

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

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.
0
MikeKNJ
Asked:
MikeKNJ
  • 3
1 Solution
 
sampipesCommented:
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.
0
 
MikeKNJAuthor 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.
0
 
MikeKNJAuthor 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!
0
 
MikeKNJAuthor Commented:
Was extremely helpful!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now