Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Login failed for user 'NT AUTHORITY\SYSTEM' Expand / Collapse
Author
Message
Posted Friday, June 6, 2014 12:01 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, August 7, 2014 7:41 AM
Points: 83, Visits: 454
We are continuously observing the below server some serves.

Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the explicitly specified database 'XXXX'. [CLIENT: XXX]

I recreated the login.It didnot work.
Post #1578152
Posted Friday, June 6, 2014 2:50 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:37 PM
Points: 2,348, Visits: 2,851
Open the properties of the LOGIN and look at the specified default database. Does this database exists?

According to the error message you have specified a non-existing database, the database is unavailable (offline?) or the LOGIN doesn't have access to the database.


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1578199
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse