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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2012-07-23 : 10:30:12
|
| Hi,We are in the process of moving from cluster to standalone vm servers. We have 3 named instances on cluster. Our plan is create 3 vm and installed sql named instances on them, then move databases and all objects to them. My question is: If we give vm different name but installed same instance name, is it possible? i.e rose\instance1 to stars\instance1 on the same domain.Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-07-23 : 10:37:11
|
| You could do it that way, but if you're putting a single instance on each VM why not use the default instance? |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2012-07-23 : 12:50:10
|
| We will put 2-3 instances on one vm. I just want to use the same instance name on new vm. That may help from application side (connection string). Our plan is to create CNAME for new VM so that there should not any problem from application side. We will not change connection string from application side. CNAME will redirect traffic to new VM. My concern is to keep 0 changes on application side. Is there any issue with CNAME setup? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-07-23 : 13:12:29
|
| None that I know of. |
|
|
|
|
|
|
Instance Name