This procedure describes how to set up a cluster database with Microsoft SQL Server database. Below configuration for our study case:
Installation steps
We’ll perform the installation in different steps :
1. Check prerequisites are correctly configured
2. Install the SQL Server cluster database on 1 rst node
3. Add 2nd node in the SQL Server cluster database
I. PREREQUISITES
In order to avoid some errors during installation, it’s important to verify below actions have been configured :
1. Installation of windows server cluster to host the database
NB : In our case, the cluster of Windows server is configured and the cluster name is : CLUS-DBC12
2. Add the name of SQL Server cluster in Active Directory
i/ In Active Directory, check there is a line for SQL Server cluster with corresponding IP like below :
SQLWINE Host(A) 192.168.29.93
ii/ Grant “Full Control” on the SQL Server cluster (SQLWINE) to the windows server cluster (CLUS-DBC12)
3. Check component .NET 3.5 is installed
Check or install this component on each node of the windows cluster
II. INSTALLATION OF CLUSTER ON NODE 1
1. DOWNLOAD SOFTWARE
Here, we’ve downloaded the ISO software for SQL Server 2017 named: SW_DVD9_NTRL_SQL_Svr_Ent_Core_2017_64Bit_English_OEM_VL_X21-56995.ISO. Do right click on the file and « Mount » the software as below :
A new DVD will appear in list of drives :
2.Installation of cluster Database
Double click on the DVD to open it. Right click and run Setup as Administrator :
Choose second menu « Installation » on the left window :
In the right panel, choose « New SQL Server failover cluster installation »
The software key is automatically filled. Click Next.
Check the box and Next
Don’t check the “Update” box and Next
Installation checks for prerequisites. 2 warnings mentioned here
You can check details about the warnings by clicking on the “Warning” link
Select the products to be installed.You can check “Select All” to select all the products. But for « PolyBase Query… » product, be sure to install ORACLE JRE …
Otherwise you’ll get error like below :
Here we choose to uncheck this product to continue installation
System will check for prerequisites for products selected
Specify the Network Name (here SQLWINE) and instance to create. You can choose the default instance or a named instance (here SQLWIN). Click Next
Leave the default cluster resource selected and click Next
The system shows candidate disks which can be added to the cluster in creation
Check and Add « Cluster Disk 4 » in the cluster and click Next
Installation will detect the informations corresponding to the mask and subnet of the node
Enter the address of the SQL Server cluster (here 192.168.29.93 for the cluster SQLWINE) and Next
Specify the account for the configuration of cluster services. Here, we’ve used a domain account with admin privileges
In the « Collation » tab, you can choose the required collation for the instance. Click Next
Choose the authentification mode. Here, we’ve chosen mixte mode. Enter password for account ‘SA’.
NB : You can change the authentication mode after cluster installation.
You can also add admin accounts for the SQL Server instance.
In the «Data Directories » tab, you can choose directories for datafile types
In the «TempDB » tab, choose options for the configuration of TempDB. Specify also the log directory for the instance and Next
You can add admin accounts for « Analysis services »
In the « Data Directories » menu, choose directories for « Analysis services »
Check and review list of products and configurations to be installed. Click on “Install” to begin installation.
Installation progress …
Check installation completion
This completes the installation of SQL Server cluster on node 1. Verify the resource cluster « SQLWINE » is available in the roles of the Windows cluster “CLUS-DBC12”.
III. ADD NODE 2 TO THE SQL SERVER CLUSTER
Like on node 1, mount the DVD of SQL Server software and run Setup. Choose «Installation » in the left panel
Choose «Add node to a SQL Server failover cluster» in the right side
The product key installation is automatically filled
Check the box and Next
Don’t check the “update” box and Next
Check the prerequisites. You can ignore warnings and Next to continue with installation
The installation detects the cluster SQL server installed and instance created. Click Next to add current serveur as another node of the cluster selected
Check the box to add the available node to the SQL Server cluster
Indicate accounts for configuration of SQL Server services:
Review informations before installation. Click « Install » to begin installation
Progression of installation of products …
Check products are correctly installed
This completes the adding of the second node in the SQL Server cluster database.
With the client SQL Server Management studio, check instance SQLWINE\SQLWIN is available.
BLOG DBA TIPS AND TRICKS 