Create SQL sever 2005 clustering in existing non cluster SQL 2005

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
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.
"James" wrote:

> 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
|||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:
[vbcol=seagreen]
> 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.
>
> --
> "James" wrote:
|||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.
--DatabaseAdmins.com, LLC
Remote DBA Services for SQL and Oracle.
"James" wrote:
[vbcol=seagreen]
> 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:
|||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:
[vbcol=seagreen]
> 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.
> --
> --DatabaseAdmins.com, LLC
> Remote DBA Services for SQL and Oracle.
>
> "James" wrote:
|||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:
[vbcol=seagreen]
> 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:
|||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:
[vbcol=seagreen]
> 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:
|||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.
"James" wrote:
[vbcol=seagreen]
> 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: