Post reply

exec sys.xp_enumerrorlogs 1 ERRORS out

  • November 13, 2008 at 11:08 am

    #124308

    I execute:

    exec sys.xp_enumerrorlogs 1

    and get:

    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

    Running exec sys.xp_enumerrorlogs 2 is fine.

    Any ideas why this is happening???

  • November 26, 2008 at 3:24 pm

    #904072

    UPDATE:

    I also get the same error when I run the following:

    exec xp_readerrorlog

    To explain more on my first posting...

    I did a trace to see why I was not able to open SQL Server Logs from SSMS and it tries to execute sp_enumerrorlogs -- which tries to execute exec sys.xp_enumerrorlogs,1 and exec sys.xp_enumerrorlogs,2. exec sys.xp_enumerrorlogs,1 fails, while exec sys.xp_enumerrorlogs,2 is successful. So, for some reason it can't find the locations of my errorlog. But, the errorlog is where it has always been and is being written to successfully.

    Have a Happy Thanksgiving!!! 🙂

  • October 5, 2017 at 12:46 pm

    #1962545

    schep021

    I was wondering if you ever found the fix for this issue.  i am having the same issue on a SQL Server 2014 installation. 

    Any feedback is appreciated.

    Jeff

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply