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

Posted on 2009-02-11
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.
Question by:MikeKNJ
    LVL 5

    Accepted Solution

    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.

    Author Comment

    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 Comment

    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 Closing Comment

    Was extremely helpful!

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now