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

Unable to access SQL Instance Expand / Collapse
Author
Message
Posted Thursday, August 29, 2013 10:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 07, 2014 4:36 AM
Points: 2, Visits: 37
Hi,

I am in desperate need of some help with a problem I am having.

SQL Server 2005 named instance on a cluster.

I was working on testing some audit triggers and there must have been a syntax error because now I can't login with any account.

I have managed to disable the cluster, stop SQL Server and restart from the command line in single user mode. However, I am unable to connect to it using SQLCMD as it says that remote connections are not possible. I am unable to configure remote connections as it times out.

So basically I am stuffed at the moment and unable to recover access to this instance to remove the problem trigger.

Anyone got any workarounds? Getting desperate now

Alex
Post #1489795
Posted Friday, August 30, 2013 9:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 07, 2014 4:36 AM
Points: 2, Visits: 37
This is now resolved.

Managed to start SQL Server in single user access mode and login using named pipes through SSMS. Removed the offending trigger and bobs your uncle.
Post #1490201
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse