Post reply

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

  • January 19, 2012 at 10:49 am

    #391357

    Hi all,

    I have like 1 zillion messages like the ones below on a production SQL Server 2008 R2 ERRORLOG:

    2012-01-17 17:300.49 Logon Login0: failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]

    2012-01-17 17:30:00.49 Logon Error: 18456, Severity: 14, State: 38.

    2012-01-17 17:30:00.49 Logon Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]

    2012-01-17 17:30:00.50 Logon Error: 18456, Severity: 14, State: 38.

    2012-01-17 17:30:00.50 Logon Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]

    2012-01-17 17:30:00.50 Logon Error: 18456, Severity: 14, State: 38.

    What does it mean exactly and how can I fix this?

    Any help is appreciated.

    Mario

  • January 19, 2012 at 11:42 am

    #1436102

    It sounds like the default database that the login is associated to has been dropped.

    Check the login properties. See what default database it is associated with. If the database no longer exists, the property should be blank.

    Then I advise assigning a database that is unlikely to get deleted as the default, which should make the error messages go away.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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