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.
| Author |
Topic |
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
 Posted - 2003-04-14 : 10:53:44
|
| I have a SQL 2K active/active cluster. A default instance is on one node and a named instance is on the other. There is replication and linked servers between the machines.I need to rename the boxes.Any lessons learned for me?I understand that in a simple, single default instance SQL installation, you just change the name of the machine, boot up, then sp_dropserver / sp_addserver to fix the name in sysservers...That much is in BOL. I'm uncertain what will happen with my cluster and replication ....Jay White{0} |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-14 : 13:37:52
|
| Jay, I am faced with a similar problem. I don't need to rename the box, but I do need to rename the instance. It is a clustered server. The instance is named HASDSQL\GTW. It needs to be renamed to HASDSQLGTW\GTW to follow our naming standard. I think that all that I need to do is run sp_dropserver/sd_addserver to accomplish this, but I'm not sure. Do you have any insights on this?Tara |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-14 : 19:50:04
|
| Well I wasn't able to just run sp_dropserver/sp_addserver. I ran the stored procedures but then tried connecting to it through QA and couldn't. Looks like I am going to have to reinstall SQL Server unless someone else can help me out on this. Luckily this isn't production yet.Tara |
|
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2003-04-15 : 02:50:35
|
| From www.sql-server-performance.com/clustering_2000.aspTip: Once SQL Server 2000 clustering in installed, use the SQL Server Setup program to make changes to the cluster's configuration.Explanation: It is very important that you use the SQL Server Setup program to make many SQL Server clustering changes, otherwise you risk corrupting your installation. The following must be performed from the Setup program:Change the virtual cluster name Change the virtual cluster IP address Adding or removing cluster nodesHTHFranco |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-15 : 11:34:01
|
| Thanks Franco! I'll give that a try. I have done very little work on clustering, so this arena is fairly new to me.Tara |
|
|
|
|
|
|
Renaming a Server