Install Microsoft SQL Server

For those unfamiliar with the installation procedure for Microsoft SQL Server, below is an example of the steps to follow for installing Microsoft SQL Server 2014.  (If you are installing a different version of Microsoft SQL Server, you will need to follow the installation guide included with that version of SQL Server and configure it accordingly.)  Please note that this is only meant to be used as a general point of reference, and not a comprehensive guide to installing Microsoft SQL Server.

1. Verify that you are logged in as a user with administrative rights, and begin the Microsoft SQL Server setup.  The starting window will display; accept the terms and click Next.
   
   
   
   
2. Enable the option to check for updates and then click Next.
   
   
   
   
3. Wait for the updates and setup files to be downloaded.
   
   
   
   
4. When the Feature Selection screen appears, select the features that you wish to install.  At a minimum, please select the options shown below and click Next:
   
   
   
   
5. In the Instance Configuration screen, enter the desired instance name and click Next.  Be sure to write down this instance name for future reference.  In this example, we will use "PRISM" for the instance name.
   
   
   
   
6. In the Server Configuration screen, click on the Account Name dropdown for "SQL Server Database Engine" and select "<<Browse...>>".
   
   
   
   
7. Enter "system" into the text field, and then click OK.
   
   
   
   
8. If the Multiple Names Found screen appears, select the user named "SYSTEM" and click OK, and click OK again.
   
   
   
   
9. Click on the Startup Type dropdown for "SQL Server Browser" and select "Automatic".
   
   
   
   
10. Verify your screen matches the screenshot below, then click the Collation tab.
    
    
    
    
11. Verify that the database engine's collation is set to "SQL_Latin1_General_CP1_CI_AS" and click Next.
    
    
    
    
12. In the Database Engine Configuration screen, the currently logged-in user account should already be added to the list of SQL Server administrators.  If this user account is not listed, please click the Add Current User button.  Then click the Add... button to define additional SQL Server administrators.
    
    
    
    
13. Enter "system" into the text field, and then click OK.
    
    
    
    
14. If the Multiple Names Found screen appears, select the user named "SYSTEM" and click OK.
    
    
    
    
15. Verify that "NT AUTHORITY\SYSTEM (SYSTEM)" is now shown in the list of SQL Server administrators.  If necessary, click the Add... button again to specify additional SQL Server administrators.  When finished, verify the list of SQL Server administrators is correct and click Next.
    
    
    
    
16. Wait for the installation process to complete.
    
    
    
    
17. Once the installation process is complete, click Close.