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)

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

  • 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

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.