SQL Server Installation For HA

The principal goal of a SQL Server High Availability (HA) solution is to minimize the impact of downtime and provide redundancy for databases throughout the enterprise.

Checklist for Domain Controller

  • Change network adapter to bridged
  • Disable windows firewall
  • Enter IP address:  192.168.0.50
  • Restart VM
  • Change computer name DC
  • Create domain (SQL)
  • Start server from domain user clusteradmin account
  • Disable server manager popup window
  • Turn of Internet Explorer (IE) popup
  • Set the option for enabling sharing of folders

Checklist for server 1

  • Make sure the DC is powered on
  • Change network adapter to bridged
  • Disable windows firewall
  • Enter IP address:  192.168.0.51
  • Restart VM
  • Change computer name Server1
  • Join domain (SQL)
  • Start server from domain user clusteradmin account
  • Disable server manager popup window
  • Turn of Internet Explorer (IE) popup
  • Set the option for enabling sharing of folders

Checklist for server 2

  • Make sure the DC is powered on
  • Change network adapter to bridged
  • Disable windows firewall
  • Enter IP address:  192.168.0.52
  • Restart VM
  • Change computer name Server2
  • Join domain (SQL)
  • Start server from domain user clusteradmin account
  • Disable server manager popup window
  • Turn of Internet Explorer (IE) popup
  • Set the option for enabling sharing of folders

Checklist for server 3

  • Make sure the DC is powered on
  • Change network adapter to bridged
  • Disable windows firewall
  • Enter IP address:  192.168.0.53
  • Restart VM
  • Change computer name Server3
  • Join domain (SQL)
  • Start server from domain user clusteradmin account
  • Disable server manager popup window
  • Turn off Internet Explorer (IE) popup
  • Set the option for enabling sharing of folders
SQL Server High Availability

Summary of step to Configure SQL Server High Availability:

  • Created 4 virtual machine on free VMware software
  • One Domain Controller (DC)
  • Three virtual Servers (Server1, Server2, Server3)
  • Configured the virtual servers (changed sever name, IE off, disable firewall, IP address, etc.)
  • Joined SQL domain
  • Installed SQL Servers 2016 on each virtual server – except the DC
  • Updated the free VMware workstation to 30 day trial version to manage easier with tabs
  • Uploaded the four VMs from the path of VMs

Installing MS SQL on Windows

  • Firstly you have to search on google Microsoft SQL server download and click on the very first link that it shows as shown below. Make sure it is a Microsoft website and not any other third-party site.

  • Then scroll down and look for Developer edition, click Download Now, and save the file. The developer edition is a full version and comes packaged with a fully featured free edition specially designed for developers.

  • Once the download is successful, go to the downloaded folder and look for the SQLServer2017-SSEI-Dev.exe file. Double click on that file, and you should see Getting things ready, which means everything is going smoothly.

  • After that, it will show you three options BasicCustom, and Download Media. You need to select the second option, which is Custom.

  • Then you will be asked where you would like your MS SQL installation files to reside, choose accordingly, and click on Install. Make sure you have good internet connectivity. In the meantime, feel free to take a short nap since it will take some time to install.

  • Once the download is complete, you shall see download success. It will take you to the next steps that are necessary. A new window with the SQL Server Installation Center will open, which will have planning, installation, maintenance, etc. You need to click on installation and then on the right side of the panel you will find multiple options, you need to select New SQL Server stand-alone installation or add features to existing installation.

  • Then it will open the SQL Server 2017 setup window in which, by default, the checkbox with specify a free edition to Developer would be selected. All you need to do is click next and accept the license terms and again click on next. It will install the setup files and move to the next step, which is install rules. You might get a warning of windows firewall, which you can safely ignore.

  • Then you will be directed to the Feature Selection setup in which you will find a lot of options to select from, like instance features, database engine services, machine learning services, etc. You need to select the Database engine services and click next.

  • In the instance configuration, specify an instance name that will be later used to connect to the SQL server. Let’s name it Datacamp_Sql and click next. You can skip the Server configuration and directly move on to the database engine configuration.

  • In database engine configuration, select mix mode as the authentication mode, specify the password, i.e., [email protected] and click on add current user. Remember that this password will be used with the instance name that you had created in the previous step. Finally, click on install.

  • Now you will be in the installation progress mode, wait for a while, and let the installation complete. Once the installation is complete, you will receive an Installation successful in the detail box. Feel free to close the SQL server setup window.

SQL Server Management Studio (SSMS)

https://msdn.microsoft.com/en-us/library/mt238290.aspx

  • Once the installation is complete, you should see a file named SSMS-Setup-ENU in your downloaded folder. Double click on that file and select Yes. Then click on Install, it will take some time for it to complete again depending upon your internet connection. You might be asked to restart your system for the installation to complete. Once the setup is complete, click on close.

  • Finally, you can close the SQL server installation center. Go to windows start and search for Microsoft SQL Server Management Studio, and you should be able to find it, once you open it the UI should look similar to one shown below:

  • It will show you a connect to server option with multiple parameters like Server Type, Server Name, Authentication, etc. Click on server name and select browse for more in that select Database engine. Once you select Database Engine it would show you the instance name you had created in instance configuration, click ok.

  • Then in the Authentication, select SQL Server authentication. It’s important to note that the login will be default name i.e., sa, and the password will be the same as you had created in the earlier steps.

  • As a final step, just click on Connect. Once connected, you should see the Datacamp_SQL server that you had created listed on the object explorer panel, which means that you have successfully established a connection with your local SQL server. And you are all set to create a database, add, delete and insert in it.

Awesome, so you were successful in installing SQL Server High Availability