Adding additional "SQL Server Network Name" for exisiting instance of SQL 2008 (Windows 2008 Cluster)

Question

Hi All,


I would like to add a new network name and IP address for the existing instance of sql server 2008 cluster. I was able to add the network name qnd IP address to SQL Server cluster group and added the network name as dependency to "SQL Server" resource the same worked perfectly fine on Windows 2003 cluster but it is not working on 2008 cluster.

Existing Server Details :-

Old Cluster Domain Name = OLDSQLServer (Old SQL Server Name )

Old Cluster Network IP Address = 10.x.x.x (OLD SQL Server IP)


New required additions to the Server :-

New Domain Name = NEWSQLServerNetwork Name (This domain entry and IP also should connect to OLDServer)

Thanks in advance 

 

---

Please click "Mark as Answer" if the post solves your problem - Thanks

Answer 1

In the properties window of "SQL Server" resource even though I added the newly created network name as dependency, I still not able to connect to the SQL Server using the new name.

I see only "OLD Network name" as VirtualServerName in "SQL Server" service proprties tab.

---

Please click "Mark as Answer" if the post solves your problem - Thanks

Answer 2

FYI - I was able to start the SQL Server service with either OLD_NAME and OLD_IP or NEW_NAME and NEW_IP but not with both the names.

---

Please click "Mark as Answer" if the post solves your problem - Thanks

Answer 3

Hi Venu S,

You issue is related to SQL Server Cluster, so I move it to this forum.  In this forum, you could receive better and quicker support.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 4

Thanks Maggie. Appreciate your help.

---

Please click "Mark as Answer" if the post solves your problem - Thanks

Answer 5

Why would you like to add a new network name for your existing instance? Any specific reason?

A clustered SQL Server instance is no different from a stand-alone instance when it comes to instance name and IP address. You can only have one instance name and a corresponding IP address for that instance. If your goal is to have a different name that the applications will use to connect to the instance, your easiest way is to use a DNS alias. For example,

Clustered Instance Name: TESTCLUSTER

Clustered Instance IP: 192.168.0.11

Create a DNS alias named TESTACCESSCLUSTER and map it to the IP address 192.168.0.11. This abstracts the real name of the database server instance name from the application while still allowing it to connect to the database. This can be applied to stand-along SQL Server instances as well. 

---

Edwin Sarmiento SQL Server MVP
Blog | Twitter | LinkedIn