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.
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.