Install SQL Server

Install SQL

  1. Download Microsoft SQL.
     
  2. Double-click the install file. A 'User Account Control' dialog appears. Click 'Yes' on the dialog.

     
  3. A dialog may appear announcing that ".Net Framework 3.5" needs to be installed. If so, choose 'Download and install this feature." When finished, click Close.

     
  4. The SQL Server Installation Center appears. Click on the Planning category and then on the "System Configuration Checker" to verify there are no problems.

     
  5. If problems are found, resolve them. If no problems are found, click OK to close the configuration checker.

     
  6. Click on the Installation category.

     
  7. Click on New SQL Server stand-alone installation...

     
  8. The Install Wizard starts and a License Terms box appears. Click "I accept the license terms" and then click Next.

     
  9. The system installs support files.

     
  10. Next, Feature Selection appears. Leave all defaults in place and click Next.

     
  11. Next, Instance Configuration appears. Change the instance to the "Default Instance" setting. Click Next.
    THIS STEP IS THE MOST OFTEN MISSED. YOU MUST CHANGE TO THE DEFAULT INSTANCE.

     
  12. Next, Server Configuration appears. Click the "Use the same account for all SQL Server services" button. 

     
  13. Click the drop-down box for the Account name and choose NT AUTHORITY\SYSTEM. Click OK.

     
  14. Click Next to proceed.

     
  15. Next, the Database Engine Configuration appears. Under Authentication Mode, select Mixed Mode.

     
  16. Enter an SA password for the database (make sure to follow best practices for complex passwords). Make sure to record the password for later use.

     
  17. Click Next to proceed.
     
  18. Click Next to proceed past Error Reporting and start the install. 
     
  19. When the install completes, click Close.

     

Configure SQL for TCP/IP

  1. Click Start and Choose SQL Server Configuration Manager (this may trigger a UAC dialog. Click Yes.)
     
  2. Click on SQL Server Network Configuration.

     
  3. Double-click on Protocols.

     
  4. Right-click on TCP/IP and choose Enable.


     
  5. Click on SQL Server Services.

     
  6. Right-click SQL Server and choose Restart. This will restart the SQL Server and apply the setting change.

     
  7. Close the Server Configuration Manager.