Create SQL sever 2005 clustering in existing non cluster SQL 2005

03-14-07, 05:56 PM

James

Hi (I send one before but looklike it did not pass through)
I have questions as below.
1) On production server win 2003 64 bits, I can not see Cluster by
ClusterAdmin, Quarum is the folder in C:\Drive, SAN is only shared drive, SQL
logon by local system account, Sql connect as (local) or ComputerName from
Management Studio. Get info from my boss, it was SQL server 2005 Ent
clustering on this server. What else should I check?
2) Get info that I need to add just only SQL Virtual server name and IP
address to make it clustering. If item#1 is true, How? Any modification?

In the case I found single instance, I will detach databases, uninstall
SQL server, make cluster, reinstall and attached databasesto shared disk but
this scenario is beyond my knowledge.
This is new to me, please help.

Thanks

03-14-07, 06:34 PM

burt_king

Please rephrase the question. Are you asking what to do if the cluster fails
and can't be found in cluster administrator or are you asking how to
reinstall sql.

It sounds like a little of both.

03-14-07, 06:54 PM

James

Thank Burt,
I am sorry for confusion.
First: In my scenario, I open ClusterAdmin but can not found any cluster in
that server, can not found quorum disk and SQL server start up logon as Local
account.
My boss told me that this is SQL server 2005 Clustering on wins 2003 64
bits. I do not beleive this is true.
--> I want to ask, How can I confirm it was true as my boss said?
Do I have enough fact as above to tell there have no clustering in this
server?
Second: If my boss correct, he said I need to create SQL virtual name and IP
address to make it clustering no need to reinstall SQL server 2005.
-->I want to ask, What should I do?

If my boss misunderstand what is the other fact that I need to support my
idea?

Thanks you so much.

"burt_king" wrote:
[..]

03-14-07, 06:59 PM

burt_king

The simplest thing to do is ask him what the virtual name of the server is.
Then go to a command prompt on the server and enter "hostname" as the
command. The return value should be different than the virtual server name.

If you're using cluster administrator correctly (note that you can look at
local as well as remote clusters) then it sounds like it's not a cluster.

03-14-07, 07:33 PM

James

Thank ypu again Burt,

I ask her and she reply that we just delete the clustering out but the SQL
that create on clustering still run. (I have no idea, but it is working so I
think it is not install in clustering)

They will create new windows clustering again. The hard part is

"they do not allow me to reinstall or create name instance but want me to
only add SQL virtual name and IP address and make it clustering".

--> last question: Is it possible to make SQL server 2005 local(I believe it
is local) to be SQL server 2005 clustering by add SQL virtual name and IP
address without reinstall (or new install) after network guy create windows
clustering? If yes,How?

Thank you so much.

"burt_king" wrote:
[..]

03-14-07, 09:03 PM

oracleSQLdba

Did you run the command at the command line and see what was returned? It's
hard to give good advice here because it seems like we're not getting the
whole picture.

Additionally, it sounds like your manager is asking if an existing instance
that is not clustered can be made a cluster without reinstalling: to my
knowledge no.

HTH

"James" wrote:
[..]

03-14-07, 09:19 PM

James

Thanks
As they said they delete the windows cluster out, and do not have SQL
virtual name. the hostname command show the server name when run that command.
Thank you for your answer.

Just coming up in my head, If you install SQL server 2005 over windows
clustering and you delete windows clustering out. Can SQL server still
survive or running? I never delete windows clustering before.

Thank you so much.

James

"oracleSQLdba" wrote:
[..]

03-15-07, 02:23 PM

oracleSQLdba

Sorry, what to you mean, "delete the windows cluster out"?

If you mean, can you uninstall windows cluster services, the answer is yes.
But if you're at the virtual server and run the hostname command and receive
that same name back then you're not likely to be on a cluster.

I think you may be best served by getting a consultant in there for a day to
look at what you've got and help you.

Similar Threads
Install SQL 2005 cluster on existing SQL 2000 SP3 cluster using the same shared cluster drive We've been asked to install SQL 2005 cluster on an existing (production) SQL 2000 (SP3) cluster. The other requirement is to use the same shared clustered drives. I know...
Install Full-Text on Existing SQL Server 2005 Cluster I need to install the full-text engine on an existing SQL Server 2005 cluster virtual instance but can't seem to figure out how. Any ideas?
Removing old CTP & Beta SQL Server 2005 to install SQL Sever 2005 Standard All, Just did a cursory look thru the postings and can't seem to find what I'm looking for... I'm just an at home tinkering kinda guy, and I was wondering if there was a...
SQL Mobile 2005, SQL Sever 2005, IBuySpyDelivery2005 I have compiled the demo app and deployed onto a device, however, it will not replicate and I can't get pas the first screen that asks for the server name. The SQL Mobile...
Virtual Server 2005 - Cluster - Clustering - Disk Errors - SCSI After using the procedure for clustering at Microsoft.com [..] I get errors binding the fixed quorum SCSI Disk. Even at virtual machine boot-up, I can see that the virtual...