none
Does TCP-IPv6 support SQL Server Standalone and Active/Passive Clustering?

    Question

  • Hi,

    Suppose  in current setup SQL Sever Standalone and SQL Server Clustering is TCP-IPv4. 

    If IP's are migrated/changed to TCP-IPv6 then will SQL Server Standalone and SQL Server Clustering work properly

    Regards,

    Nikhil P Desai

    Thursday, December 1, 2016 12:44 PM

All replies

  • Hi Nikhil,

    IPv6 supports SQL Server Standalone and Active/Passive Clustering. Besides, we don't need to configure it when we change IPv6 to IPv4, it will migrate automatically in most scenarios.

    As described in the official document, when Windows is configured with IPv6 SQL Server, components automatically recognize the existence of IPv6. No special SQL Server configuration is necessary.

    However, we need to take one scenario into consideration, when we use the IP address to connect SQL Server and configure Cluster. In most cases, the connection string does not need to be modified if the <computer_name>\<instance_name> is specified using server hostname or fully qualified domain name (FQDN). If you use the IP address\instance name, it will not work, we will configure it.

    For more information, please refer to this article.

    Best Regards,
    Teige


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Friday, December 2, 2016 7:21 AM
    Moderator