Post reply

Will the application work as usual if we create alias with existing cluster name for a new sql server instance and break cluster ?

  • July 29, 2014 at 12:54 am

    #310409

    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.

  • July 29, 2014 at 7:40 pm

    #1733436

    I don't see a reason why it shouldn't work.

    However want to conform, someone please help. Thanks.

    Samith.

  • July 29, 2014 at 9:45 pm

    #1733447

    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.

  • July 29, 2014 at 9:53 pm

    #1733449

    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.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy