Sign up ×
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)

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)

share|improve this question
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 posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.