Post reply

Unable to view sql error log on Sql Server 2008 r2

  • April 11, 2013 at 11:05 am

    #276437

    Hi,

    i have sql server 2008 r2 cluster on win 2008 server.

    We are not able view the sql error log through SSMS and by xp_readerrorlog....

    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

    Please let me know if any one faced same issue.

    MAny thanks,

  • April 11, 2013 at 11:06 am

    #1605697

    And what does the event log say regarding this?

  • April 11, 2013 at 11:17 am

    #1605703

    We are able to view the error log through application log(event viwer) and able to access error log path manually,but not able to view through SSMS and through Query window..Xp_readerrorlog...

  • April 11, 2013 at 11:23 am

    #1605704

    Doesn't tell us what additional information was included in the event log regarding the error you got.

Viewing 4 posts - 1 through 4 (of 4 total)

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