Arun Sirpal diagnoses a connection problem:
I could not read my error log on one of my local SQL Servers, when I executed the following code:
EXEC sp_readerrorlogI received the below:
Msg 22004, Level 16, State 1, Line 2 Failed to open loopback connection. Please see event log for more information. Msg 22004, Level 16, State 1, Line 2 Error log location not found.
Fortunately, the error logs had a bit more detail, so Arun has the answer for you.