Login failed, error 18456

  • Hi

    I´m getting this error in the SQL Server log and can´t find out how to fix it....

    Error: 18456, Severity: 14, State: 38.

    Login failed for user 'Domain\SERVER$'. Reason: Failed to open the explicitly specified database 'TempDB'.

    The SERVER$ is the name of the SQL server...

    I´m running SQL server ver 11.0.3401 on a Windows server 2012 R2

    I have added the server account to the SQL server but to no help.

    Removed the account from the database and added it again - no change...

    Made the account dbo on the database - no change ...

    Is there anything else that is causing the error and not the server account ??

    With regards

    Jonas

  • Other things are working fine? If server is not starting post the complete error log from start so that someone can help.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • Also confirm what is the status of login 'NT AUTHORITY\SYSTEM'?

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • free_mascot (4/10/2014)


    Also confirm what is the status of login 'NT AUTHORITY\SYSTEM'?

    Hi

    Added 'NT AUTHORITY\SYSTEM' login to the database and it seems to have fixed the problem !!:-D

    Thank You !!

    It would have been nice if it could said that in the error rmessage 🙂

    /Jonas

  • Great!!

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

Viewing 5 posts - 1 through 4 (of 4 total)

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