Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Renaming Named Instance on Cluster

Author  Topic 

dwalker79
Yak Posting Veteran

54 Posts

Posted - 2008-07-31 : 10:14:39
Hello,

I have a question. We are moving databases to new servers at a new physical location. The new physical servers are currently named differently than the current production servers (because they're on the same domain). We have however already installed SQL Server 2000 on these new servers as named instances (ex. p-corp-amsdb-0a\VS001). These servers are also on a cluster.

On the day that we cutover to the new servers the server ops admins are going to rename the physical servers at the new location to their original name and shut down the old ones. My question is how do I rename the named instance from p-corp-amsdb-0a\VS001 to corp-amsdb-001\VS001? Keep in mind these are on a cluster as well. I'm hoping this can be done without having to uninstall/reinstall SQL Server 2000 on the cluster.

Any help would be greatly appreciated!

Thanks,
Dustin

dwalker79
Yak Posting Veteran

54 Posts

Posted - 2008-07-31 : 11:00:37
I'm thinking that because these are named instances and not default instances I can just simply perform the following after the servers have been renamed.

http://msdn.microsoft.com/en-us/library/aa197071(SQL.80).aspx

Can someone please confirm that this is correct?

Thanks!
Dustin
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-31 : 22:44:10
No, you can't rename named instance.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-01 : 01:02:27
On a cluster, you don't use the physical server names when dealing with SQL Server. SQL Server uses the virtual server name.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

dwalker79
Yak Posting Veteran

54 Posts

Posted - 2008-08-01 : 08:19:07
So if the virtual server names change will I need to do anything with the named instances, or will it take care of itself? The name of the actual instances aren't changing, only the server name that precedes the instance name will change.

Thanks for the input!
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-01 : 23:25:54
If you rename physical node's name, it'll not affect sql instance since instance name on cluster is virtual_sql_name\instance_name. If you rename virtual sql name, then instance will be new_virtual_name\instance_name.
Go to Top of Page

krishnarajeesh
Yak Posting Veteran

67 Posts

Posted - 2008-08-04 : 01:47:52
Lets have a look at the below scenario, with description. The physical node names are the cluster node 1 & cluster node 2. If you change that it will not affect the sql instance. SQL instance depends on the virtual server name(SQL Server Network Name).

CLS001 ## Cluster node 1 (Primary Node)
CLS002 ## Cluster node 2 (Failover Node)
CLSQL001A\CLSQL001AInstance ## SQL Network Name 2
CLSQL001B ## SQL Network Name 1
CLSQL001 ## Cluster Name


If you rename the SQL Server Network Name resource,the SQL Server virtual server instance may no longer come online.The correct way to rename a clustered SQL Server 2000 virtual server is to remove and then reinstall SQL Server 2000 by using the new virtual server name.

http://support.microsoft.com/kb/307336

SQL Server 2005
---------------

This is not true here.ie., we can rename virtual server. Refer the link pls...

http://msdn.microsoft.com/en-us/library/ms178083.aspx

Thanks,
Krishna
www.SQLServer.in
Go to Top of Page
   

- Advertisement -