Microsoft's documentation is far from clear. I need some clarification. I
need to build a test environment and then convert it to production. To
convert it to production I need to rename the server.

My present server is stand alone and is named SERVER_A. The users connect
to SQL server via query analyzer with the name SERVER_A.

My clustered server is called SERVER_A_VM and the SQL server install is
called SERVER_A_VM_SQL. I need the SQL server install named SERVER_A after I
am through with my testing. I wanted to rename it and be done.

Also, what is the name that users connect to the cluster database server.
Is itg SERVER_A_VM or is is SERVER_A_VM_SQL?

Also, Why am I not allowed to have the SQL Server name the same as the VM?
i.e. in STAND ALONE, I have SERVER_A and my SQL Server is called SERVER_A.

Just folllow the doumentation in
http://msdn.microsoft.com/en-us/library/ms178083.aspx.

Users connect to SERVER_A_VM_SQL if that is your default SQL instance name.
But it's not very clear from your description if you have installed a named
instance with SERVER_A_VM being the virtual server name and SERVER_A_VM_SQL
being the instance name, in that case users connect with
SERVER_A_VM\SERVER_A_VM_SQL.

If SERVER_A a default instance, users would connect to SERVER_A.

Linchi

"Paul" wrote:

BTW, if it's the instance name of a named instance in the cluster that you
want to rename, you are out of luck.

Linchi

"Linchi Shea" wrote:

Thank you for the reply. This was the document that I originally based all
my work from. It is correct.

The problem I ran into was a LOT of extra noise documents that were posted
on the internet that were either out dated or incorrect. It is the incorrect
ones that confused me.

Once I built the system, I played around with it and it was simple to rename
the network name - which is what the users will need to connect to when
logging into the database as opposed to logging into the server.


"Linchi Shea" wrote: