Post reply

sql server 18456 error

  • August 10, 2015 at 5:44 am

    #319687

    In a database i facing a error 18456 failed to open database.i checked the login have mapped on that database & permission db_owner and db is also not missing.

    can anyone tell me the solution?

  • August 10, 2015 at 5:55 am

    #1818497

    take a look at this thread:

    http://www.sqlservercentral.com/Forums/Topic1707571-3411-1.aspx#bm1707577

    typically, the fix is to explicitly assign master as the default database, and then cleanup the default db from there.

    the thread mentions issues that contribute, some of which you eliminated:

    the db no longer exists. it may have been dropped or renamed are typical causes.

    the db was restored from another db, so there's no permissions for the user.

    the user does not have permissions in the db at all, for whatever reason.

    a script was run that misspelled the database name when assigning the default database:

    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!

  • August 10, 2015 at 10:45 pm

    This was removed by the editor as SPAM

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

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