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: Friday, December 12, 2014 9:15 AM
Points: 85, Visits: 465
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 @ 10:40 AM
Points: 2,480, Visits: 3,023
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