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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 '14 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 '14 at 18:18
    
I checked the value of SQL sever errorlog entry and it is correct. – Fedor Jan 16 '14 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 '14 at 19:33
    
SQL server service was restarted yesterday. It runs under 'AD\user' with correct password. – Fedor Jan 16 '14 at 19:35

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.