Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Will the application work as usual if we create alias with existing cluster name for a new sql server instance and break cluster ? Expand / Collapse
Author
Message
Posted Tuesday, July 29, 2014 12:54 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 11:41 PM
Points: 1,563, Visits: 2,615
Hi Experts,

One of the SQL Server 2005 cluster database is being moved to a new standalone VM instance.
Application team has some challenges in changing DB configuration etc; So they can't point it to the new instance name.

If I create an alias for the new standalone VM instance with the same name as existing cluster name, will the application work without any issues (once they break cluster) ?. Kindly guide.


Thanks,
Smith.






Post #1597162
Posted Tuesday, July 29, 2014 7:40 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 11:41 PM
Points: 1,563, Visits: 2,615
I don't see a reason why it shouldn't work.
However want to conform, someone please help. Thanks.


Samith.
Post #1597547
Posted Tuesday, July 29, 2014 9:45 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 2:02 AM
Points: 1,252, Visits: 1,737
What sort of alias? DNS or SQL?
The cluster will have a clustered instance name, eg. server\instance. whereas the VM is probably a default instance. A SQL alias will work if there's an application server, otherwise it'll be needed on all clients.

Post #1597563
Posted Tuesday, July 29, 2014 9:53 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 11:41 PM
Points: 1,563, Visits: 2,615
Andrew G (7/29/2014)
What sort of alias? DNS or SQL?
The cluster will have a clustered instance name, eg. server\instance. whereas the VM is probably a default instance. A SQL alias will work if there's an application server, otherwise it'll be needed on all clients.



Thanks Andrew.
I was refering a SQL Server Alias.

Post #1597565
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse