Creating a SQL Server Cluster on a Failover Cluster

Installing MSSQL Server 2016 on the Source Node

1. Download the SQL Server 2016 (Windows x86-64) installation image from the following site, save it anywhere, and right-click to Mount.

https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016

2. After mounting the iso file, double-click on the setup.exe file to open.

3. The SQL Server Installation Center screen appears. Select New SQL Server failover cluster installation.

4. Complete the following steps:

• When the Feature Selection screen appears, select Database Engine Service, SQL Server Replication, Full-Text and Semantic Extractions, and Data Quality Services.

• When the Instance Configuration screen appears, input MSSQLSERVER2016 to fields SQL Server Network Name, Name Instance, and Instance ID.

• When the Cluster Network Configuration screen appears, select the IPv4 checkbox, and input an available IP Address in the Address field.

• When the Server Configuration screen appears, go to the SQL Server Agent Account Name field and click the drop-down, then Browse. Type in Administrator, then click the option to click names. Return to the Server Configuration page. Then, type in the password field and repeat these same steps for SQL Server Database Engine.

• When the Database Engine Configuration screen appears, click Add Current User at the bottom of the page.

5. Complete the Install.

Installing MSSQL Server 2016 on the Target Node

1. Download the SQL Server 2016 (Windows x86-64) installation image from the following site, save it anywhere, and right-click to Mount.

https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016

2. After mounting the iso file, double-click on the setup.exe file to open.

3. When the SQL Server Installation Center screen appears, select Add node to a SQL failover cluster.

4. Complete the following steps:

• For Service Accounts, input the Password fields as same as the source node.

• Follow the remaining setup to complete.

5. The SQL Server Failover cluster has been successfully installed on the Windows Server Failover Cluster.

Check for Fault Tolerance

Performing the switchover from Source Node to Target Node in Windows Server Failover Cluster console:

1. Log in to the Window OS on the Source Node (DKCE-NODE01) as SIOS-LKW\Administrator.

2. Go to Failover Cluster Manager, select Roles and right-click on SQL Server, then select Move – Best Possible Node.

3. Wait until the resource conversion is finished. The SQL Server is running on DKCE-NODE02.

Connect to the database via SQL Server Management Studio

To connect to the database of SQL Server 2016, follow these steps:

1. Open Microsoft SQL Server Management Studio and connect to the SQL Server 2016 database.

2. Using the script, write constant date\time stamps to the database.

3. Switchover the SQL resource to Target Node then connect to the Database on Target Node.

4. In the SQL Management Studio editor, run the command select * from <database table> to confirm the timestamps have been reflected.