First we will install SQL Server on EC2SQL1
For this Lab we will be using Developer Edition, click Next
Microsoft Update, take default and click Next
Install Failover Cluster Rules, the statuses should match below, if so click Next
Cluster Resource Group, accept the default SQL Server (MSSQLSERVER) and click Next
Cluster Disk Selection, we wil not have any shared disks listed, click Next
Cluster Network Configuration, we will be adding an IP to the 10.150.10.0/24 subnet, then click Next
This Admin account being used for the service accounts is NOT recommended on any SQL install. This is a Lab configuration.
Database Engine Configuration,
* Select Data Directories, then enter the UNC paths for the Data and Log shares as shown below, the warnings can be ignored.
* \\<DNS Name>.demosql.com\SQL-Data
* \\<DNS Name>.demosql.com\SQL-Log
* Select TempDB, remove the defaults for the Data and Log locations and replace with T:\Data as shown below, the warnings can be ignored. The T drive is an ephemeral drive and therefore more performant. * The remainder of the settings we will use the default, click Next
Review the warning message regarding using a file server and click Yes
Review the Summary and click Install
Ensure all Feature Statuses report Succeeded and click Close
SQL Server is now installed on EC2SQL1
Now we will install SQL Server on EC2SQL2
We will repeat Steps 1-19 on EC2SQL2 with the following exceptions.
SQL Server is now Installed