Post reply

SQL 2014 Cluster Setup on VMware

  • April 20, 2018 at 8:21 am

    #410448

    VMware ESXi 6.5
    Windows 2012 R2 Cluster Servers
    SQL 2014 Enterprise

    My Windows Server Clusters validation ran with just two warnings
    1. MPIO warnings   Test Disk 0 usesMicrosoft Multipath I/O (MPIO).  (this will be fixed after I get iSCSI Setup on my ESXI host waiting on more nics)
    2. Windows updates missing from both nodes.
    No errors.
    I added Luns from my Seagate NAS device on both cluster nodes and they have the same drive letter on both.

    Next I start the installation of my first SQL Cluster server and then I get the following warnings 

    server Failover Cluster Install Failover Cluster Rules Setup rules identify potential pro±lems that might occur while mnning Setup. Failures must be corrected before Setup can continue. Product Key License Terms Global Rules Microsoft Update Product Updates Install Setup Files Install Failover Cluster Setup Role Feature Selection Feature Rules Feature Configuration Rul Ready to Install Installation Progress Complete Operation completed. gassed: 20. Failed O. Warning 3. Skipped O. ul k Res Rule "DNS settings" generated a warning. The DNS search list on computer TGCS014-N2 does not match. To correct this, synchrorize the Public, not Privste/heartbeat, networks DNS entries. Perform the following check or each cluster node: Start/ControI Panel/Networking, right-click 'n the public adapter and select Properties/lntemet Protocol TCP/IP-/> Advanced-> DNS. Under the DNS tab, the following settings must be exactly the same, including DNS suffix order, acrcss all cluster nodes: DNS server listing, Append these DNS suffixes and Register in DNS. Time for the changes made to take affect will depend on your network configuration. Distributed Transaction Coordinator (MSDTC) installed (TGCSO.„ Remote registry service (TGCS014-N2) DNS settings (TGCS014-N2) Back Next Passed Passed Warning Cancel Re- run Help

    Install a SQL Server Failover Cluster Install Failover Cluster Rules Setup rules identify potential pro±lems that might occur while mnning Setup. Failures must be corrected before Setup can continue. Product Key License Terms Global Rules Microsoft Update Product Updates Install Setup Files Install Failover Cluster Setup Role Feature Selection Feature Rules Feature Configuration Rul Ready to Install Installation Progress Complete Operation completed. gassed: 20. Failed O. Warning 3. Skipped O. le Check Resu Rule "Windows Firewall" generated a warning. The Windows Firewall is enabled. Make sur± the appropriate pots are open to enable remote access. See the rules documentation at http://go.microsoft.com/fwIink{?LinkId=94DOI for information about pots to open for each feature. Cluster Remote Access (TGCS014-N2) Distributed Transaction Coordinator (MSDTC) installed (TGCSO.„ Remote registry service (TGCS014-N2) DNS settings (TGCS014-N2) Back Next Passed Passed Passed Warning Cancel Re- run Help

    Install a SQL Server Failover Cluster Install Failover Cluster Rules Setup rules identify potential pro±lems that might occur while mnning Setup. Failures must be corrected before Setup can continue. Product Key License Terms Global Rules Microsoft Update Product Updates Install Setup Files Install Failover Cluster Setup Role Feature Selection Feature Rules Feature Configuration Rul Ready to Install Installation Progress Complete Operation completed. gassed: 20. Failed O. Warning 3. Skipped O. le Check Resu Rule "Microsoft Cluster Service (MSCS) cluster verfication warnings" generated a warning. The MSCS cluster has been validated but there are warnings in the MSCS cluster validaton repot, or some tests were skipped while running the validaticn. To continue, run validation from the Windows Cluster Administration tool to ensure that the MSCS cluster validation has been run and that the MSCS cluster validation repot does not contain errors. Network binding order Windows Firewall DNS settings (TGCS014-N1) Back Passed Warning Passed Next Cancel Re- run Help

    Questions.

    1. Is it safe to continue?
    2. The DNS warning all settings are the same on both clusters I can ping FQDN from both not sure why this is a warning
    3. The firewall one I always ignore that one I know my firewall Is setup correctly.
    4.  The last one Microsoft cluster service warning is my concern.

    Thank you

    Tom

  • April 22, 2018 at 2:46 pm

    #1987805

    I see many read this.

    No one with any thoughts on this?

    I went ahead and ran the installation on my Cluster server and have successfully done failover of my sql database
    No to move the remainder over.

    Was still wondering why the warnings

    Any one with comments ?

    Thank you,

  • April 23, 2018 at 6:39 am

    #1987878

    Havent came across the DNS warning but the Firewall warning is so common.  If you are going for a named instance installation by default it uses dynamic port and that might be reason for this warning.

  • April 24, 2018 at 8:44 am

    #1988040

    trgrassijr - Friday, April 20, 2018 8:21 AM

    VMware ESXi 6.5
    Windows 2012 R2 Cluster Servers
    SQL 2014 Enterprise

    My Windows Server Clusters validation ran with just two warnings
    1. MPIO warnings   Test Disk 0 usesMicrosoft Multipath I/O (MPIO).  (this will be fixed after I get iSCSI Setup on my ESXI host waiting on more nics)
    2. Windows updates missing from both nodes.
    No errors.
    I added Luns from my Seagate NAS device on both cluster nodes and they have the same drive letter on both.

    Next I start the installation of my first SQL Cluster server and then I get the following warnings 

    server Failover Cluster <br />Install Failover Cluster Rules <br />Setup rules identify potential pro±lems that might occur while mnning Setup. Failures must be corrected before Setup <br />can continue. <br />Product Key <br />License Terms <br />Global Rules <br />Microsoft Update <br />Product Updates <br />Install Setup Files <br />Install Failover Cluster <br />Setup Role <br />Feature Selection <br />Feature Rules <br />Feature Configuration Rul <br />Ready to Install <br />Installation Progress <br />Complete <br />Operation completed. gassed: 20. Failed O. Warning 3. Skipped O. <br />ul <br />k Res <br />Rule "DNS settings" generated a warning. <br />The DNS search list on computer TGCS014-N2 does not match. To <br />correct this, synchrorize the Public, not Privste/heartbeat, networks <br />DNS entries. Perform the following check or each cluster node: <br />Start/ControI Panel/Networking, right-click 'n the public adapter and <br />select Properties/lntemet Protocol TCP/IP-> Advanced-> DNS. Under <br />the DNS tab, the following settings must be exactly the same, including <br />DNS suffix order, acrcss all cluster nodes: DNS server listing, Append <br />these DNS suffixes and Register in DNS. Time for the changes made to <br />take affect will depend on your network configuration. <br />Distributed Transaction Coordinator (MSDTC) installed (TGCSO.„ <br />Remote registry service (TGCS014-N2) <br />DNS settings (TGCS014-N2) <br />Back <br />Next <br />Passed <br />Passed <br />Warning <br />Cancel <br />Re- run <br />Help

    Install a SQL Server Failover Cluster <br />Install Failover Cluster Rules <br />Setup rules identify potential pro±lems that might occur while mnning Setup. Failures must be corrected before Setup <br />can continue. <br />Product Key <br />License Terms <br />Global Rules <br />Microsoft Update <br />Product Updates <br />Install Setup Files <br />Install Failover Cluster <br />Setup Role <br />Feature Selection <br />Feature Rules <br />Feature Configuration Rul <br />Ready to Install <br />Installation Progress <br />Complete <br />Operation completed. gassed: 20. Failed O. Warning 3. Skipped O. <br />le Check Resu <br />Rule "Windows Firewall" generated a warning. <br />The Windows Firewall is enabled. Make sur± the appropriate pots are <br />open to enable remote access. See the rules documentation at <br />http://go.microsoft.com/fwIink{?LinkId=94DOI for information about <br />pots to open for each feature. <br />Cluster Remote Access (TGCS014-N2) <br />Distributed Transaction Coordinator (MSDTC) installed (TGCSO.„ <br />Remote registry service (TGCS014-N2) <br />DNS settings (TGCS014-N2) <br />Back <br />Next <br />Passed <br />Passed <br />Passed <br />Warning <br />Cancel <br />Re- run <br />Help

    Install a SQL Server Failover Cluster <br />Install Failover Cluster Rules <br />Setup rules identify potential pro±lems that might occur while mnning Setup. Failures must be corrected before Setup <br />can continue. <br />Product Key <br />License Terms <br />Global Rules <br />Microsoft Update <br />Product Updates <br />Install Setup Files <br />Install Failover Cluster <br />Setup Role <br />Feature Selection <br />Feature Rules <br />Feature Configuration Rul <br />Ready to Install <br />Installation Progress <br />Complete <br />Operation completed. gassed: 20. Failed O. Warning 3. Skipped O. <br />le Check Resu <br />Rule "Microsoft Cluster Service (MSCS) cluster verfication warnings" <br />generated a warning. <br />The MSCS cluster has been validated but there are warnings in the <br />MSCS cluster validaton repot, or some tests were skipped while <br />running the validaticn. To continue, run validation from the Windows <br />Cluster Administration tool to ensure that the MSCS cluster validation <br />has been run and that the MSCS cluster validation repot does not <br />contain errors. <br />Network binding order <br />Windows Firewall <br />DNS settings (TGCS014-N1) <br />Back <br />Passed <br />Warning <br />Passed <br />Next <br />Cancel <br />Re- run <br />Help

    Questions.

    1. Is it safe to continue?
    2. The DNS warning all settings are the same on both clusters I can ping FQDN from both not sure why this is a warning
    3. The firewall one I always ignore that one I know my firewall Is setup correctly.
    4.  The last one Microsoft cluster service warning is my concern.

    Thank you

    Tom

    check the nameserver details on each node and also the nic provider order

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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