Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error while running xp_readerrorlog Expand / Collapse
Author
Message
Posted Thursday, February 18, 2010 12:41 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
I can run xp_readerrorlog when server is not in single user mode. I get ''Failed to open loopback connection'' error while running xp_readerrorlog once I start my standalone sql 2005 instance in sigle user mode(using ;-m in start up parameters in config. mgr.).

Why am I getting this error?

Thanks,
MJ
Post #868431
Posted Friday, February 19, 2010 1:09 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 14, 2014 4:48 AM
Points: 2,834, Visits: 3,950
try sp_readerrorlog

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #868809
Posted Friday, February 19, 2010 5:35 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
Same error with sp_readerrorlog too...
Post #868982
Posted Friday, February 19, 2010 5:43 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 14, 2014 4:48 AM
Points: 2,834, Visits: 3,950
First , Are you using sql 2008 ?
and second thing ( blind guess) use sa(administrator) account to run it


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #868988
Posted Monday, February 22, 2010 12:01 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
Its 2005 and I am using admin account for the same.

Mj
Post #870605
Posted Tuesday, February 23, 2010 3:36 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:08 AM
Points: 2,858, Visits: 3,182
sp_readerrorlog needs to open a new connection to get to the data. You are in single user mode and are already using the only connection available.

You can always read the error log using some other tool, such as Notepad.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #871012
Posted Tuesday, February 23, 2010 2:31 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
Thanks for the Explanation.
Post #871473
Posted Tuesday, April 2, 2013 5:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, March 3, 2014 4:05 AM
Points: 47, Visits: 236
hi how you got for answer this..

same error coming in one of my server.

i have made localhost servername entry in hostfile ..
then restarted server ..

it works ..

regards,

HEMANT..
Post #1437837
Posted Friday, April 12, 2013 2:22 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 30, 2014 4:30 AM
Points: 174, Visits: 179
Had similar issue with SQL Server running with encrypted connection.

Resolved by securing certificate includes localhost as one of the common name entries under the certificate "subject".
Post #1441604
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse