[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1170
  • 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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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