Post reply

Login failed after database offline

  • April 15, 2011 at 4:01 pm

    #235792

    we identified some older sharepoint databases on a developer server that no longer in use, so I took them offline.

    But now I got a lot of error messages in sql log and Application log it says:

    Login failed for user 'ourdomain\c1sqlservicesq'. [CLIENT: <local machine>]

    This account is used for sql server and sql server agent services account.

    What does this mean, how can I fix it so that it doesn't generate the error every minutes.

    Thanks

  • April 15, 2011 at 4:20 pm

    #1312388

    i believe you want to change the default database for that login to master or some other database, now that the original default database for that login is removed.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • April 15, 2011 at 4:28 pm

    #1312389

    That is one thing i checked, thanks.

    I just found out there is a job of sharepoint created that tries to delete sessions every minute, after disable it, it all work fine now.

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply