Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

There are two SQL Server 2012 instances on the server. Named instance gives following error when Management > SQL Server Logs is clicked. Default instance works OK and opens Log file viewer.

Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
Standard Edition

TITLE: Microsoft SQL Server Management Studio
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
A severe error occurred on the current command. The results, if any, should be discarded. (Microsoft SQL Server, Error: 0)

share|improve this question
1  
What happens when you run EXEC sys.xp_readerrorlog on the instance? –  Max Vernon Jan 16 at 0:36
    
Msg 22004, Level 16, State 1, Line 0 Failed to open loopback connection. Please see event log for more information. Msg 22004, Level 16, State 1, Line 0 Error log location not found. –  Fedor Jan 16 at 18:18
    
I checked the value of SQL sever errorlog entry and it is correct. –  Fedor Jan 16 at 18:20
    
When EXEC sys.xp_readerrorlog is executed following message is recorded in application log. Login failed for user 'AD\user'. Reason: Could not find a login matching the name provided. [CLIENT: IP]. –  Fedor Jan 16 at 19:33
    
SQL server service was restarted yesterday. It runs under 'AD\user' with correct password. –  Fedor Jan 16 at 19:35
show 1 more comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.