• I am having the same issue (unable to read the sql ERRORLOG trhough SSMS or sp_readerrorlog).

    sp_readerrorlog error message:

    Msg 22004, Level 16, State 1, Line 0

    error log location not found

    Msg 22004, Level 16, State 1, Line 0

    Failed to open loopback connection. Please see event log for more information.

    What I can say with a high level of confidence is that it has nothing to do SSMS. My specific issue is with reading the ERRORLOG on a SQL Server 2005 Express Edition instnace (multiple to be more exact) which is running Windows Vista. The same SSMS client is able to read the ERRORLOG on approximately 70 other SQL Server Instances.

    I still do not know what the solution is but am wondering if it may have something to do with firewall \ security \ networking settings or possibly MSDTC.

    I will provide feedback when I find a solution - if anyone has additional ideas I would appreciate the help.

    Thanks,

    Jack