Evicted Last Server from 2003 Cluster – Databases won’t start

5 pts.
Tags:
Cluster
SQL Server 2000
Windows Server 2003

**First submit blanked out all the original content** Sorry

Environment - Windows Server 2003 SP1, SQL Server 2000 .exe version 2000.080.0760.00

I am helping to remove the clustering and migrate all databases on the cluster to a single machine in the cluster. I was able to evict Server 1 from the cluster and all DB started on Server 2 successfully. I followed MS Technet instruction to evict Server 2 from the cluster (having no clustering left) and then the databases would not start.

 - The error in SQL Manager is (Connection Failed, check SQL Server Registration Properties) Also - the Manager returns: A connection could not be established to (DB Name) Reason: SQL Server does not exist or access denied. ConnectionOpen (Connect()).. Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the DB name node) and try again.

 - When attempting to start the error is: An error 1722 - (The RPC server is unavailable) occured while performing this operation on the MSSQLServer service

- Event Viewer shows nothing related to attempting to start up an instance

Please note I am not even a SQL novice so luckily this is a non-production test before trying this on production.

If anyone can lend some knowledge on how I can fix this and how we should have done this to begin with it would be much appreciated.

Also - please go easy on the n00b.

Thank you in advance!

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:8.0pt; mso-para-margin-left:0in; line-height:107%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;}
ASKED: November 20, 2013  9:38 PM
UPDATED: November 26, 2013  5:48 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Max, Max, Max…


There is no way to convert a clustered SQL Server instance to a standalone SQL instance.  The closest you can come is a single node cluster.  To do this you’ll have to stand up a new server, install SQL Server on it, then migrate the databases to it.  Then destroy the cluster and rename the standalone machine to the same name that the cluster was using so that the applications can all connect.  SQL will then need to be told that what the servers new name is.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following