none
SQL Server ent ed installation on Windows Server core Failover cluster RRS feed

  • Question

  • Hi, I am chasing any information to assist in doing a SQL Server 2019 enterprise edition install on a 2 node Windows Server core.

    The process to install clustered sql server on normal windows server cluster is understood and done many times.  In this case it is installation on Server core.

    Information on MS sites for pre-reqs etc do not provide any detailed information of a sql cluster install on server core so I am not even sure its supported?

    Any help or advice would be appreciated.

    Derek

    Monday, December 2, 2019 3:07 AM

All replies

  • Hi Derek Harper,

    Here are some articles might helpful to you:

    https://virtualhobbit.com/2015/08/17/create-a-microsoft-sql-2014-failover-cluster-on-windows-server-2012-r2-server-core/

    https://github.com/SQL-FineBuild/Common/wiki/Installing-SQL-Server-on-Windows-Core

    In addition, Installing SQL Server 2019 on Server Core mode is supported by Windows Server 2019 Core and Windows Server 2016 Core.

    Best Regards,

    Amelia Gu


    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.

    Tuesday, December 3, 2019 8:24 AM
  • Hi Amelia, thanks so much for the links, I will have a read.

    Regards

    Derek

    Tuesday, December 3, 2019 11:58 PM
  • Hey Harper, 

    -create VM (2 or more based on requirement) and DC VM

    - Add to domain 

    -Allocated the IP address and name for the cluster

    -Add the server to be the part of the cluster

    Node 1 and node 2.

    - validate the cluster 

    - Allocate the SQL server network name and IP 

    Install SQL server on Node 1- Installation select Failover cluster installation - Provide SQL server Network name and IP in the installation step

    Install SQL server on Node 2- Installation select add nodes and used the same SQL server Network name and IP in the installation step

    - SQL server config manager - enable always  on features on both nodes

    -Allocate the IP for listener and listener name 

    - Primary node - SSMS - create New avilabilty group and provide the listener IP and name


    Wednesday, December 4, 2019 12:25 AM