SQL Server Installation


SQL Server 2016 Installation
  1. Download SQL Server Express.  Downloads
  2. Click <Run> on the File Download - Security Warning.

    Download Security Warning

  3. Click <Yes> on the User Account Control prompt.

    UAC Warning

  4. Click <Ok> on the Choose Directory for Extracted Files prompt.

    Extract

  5. Wait for the files to extract.

    Extracting

  6. Click New SQL Server stand-alone installation or add features to an existing installation on the SQL Server Installation Center window.

    SQL Server Menu

  7. Accept the License Agreement and Click <Next>.

    License Agreement

  8. Select Use Microsoft Update and click <Next>.

    Microsoft Update

  9. Click <Next> on the Product Updates window.

    SQL Server Update

  10. Wait for the updates to complete.

    Wait

  11. Click <Next> on the Setup Rules window.

    SQL Server Rules

  12. Click <Next> on the Feature Selection window.

    SQL Server Features

  13. Click <Next> on the Instance Configuration window.

    SQL Server Instance Configuration

  14. If you are using a multi-user program, change Disabled to Automatic. Click <Next>.

    SQL Server Server Configuration

  15. Change Windows authentication mode to Mixed mode (SQL Server authentication and Windows authentication), enter a password and click <Next>. This password is used to connect to the SQL Server instance. The password 'rw4!123' is the SDR Software Support standard.

    SQL Server Database Engine Configuration

  16. Wait for the program to install.

    SQL Server Installing

  17. Click <Close> on the Complete window.

    SQL Server Complete

Back to Top

SQL Server 2017 Installation
  1. Download  SQL Server Express 2017.
  2. Click <Run> on the File Download - Security Warning.

    Download Security Warning

  3. Click <Yes> on the User Account Control prompt.

    UAC Warning

  4. Select Custom installation type.

    SQL 2017 Menu

  5. Click <Install>.

    Target

  6. Wait while the program is downloaded and installed.

    Downloading

  7. Click New SQL Server stand-alone installation or add features to an existing installation on the SQL Server Installation Center window.

    SQL Server Install Menu

  8. Accept the License Agreement and Click <Next>.

    License Agreement

  9. Click <Next> on the Setup Rules window.

    SQL Server Rules

  10. Click <Next> on the Feature Selection window.

    SQL Server Features

  11. Click <Next> on the Instance Configuration window.

    SQL Server Instance Configuration

  12. If you are using a multi-user program, change Disabled to Automatic. Click <Next>.

    SQL Server Server Configuration

  13. Change Windows authentication mode to Mixed mode (SQL Server authentication and Windows authentication), enter a password and click <Next>. This password is used to connect to the SQL Server instance. The password 'rw4!123' is the SDR Software Support standard.

    SQL Server Database Engine Configuration

  14. Click <Accept> and <Next> to install Microsoft R Open.

    SQL Server R Open

  15. Click <Accept> and <Next> to install Python.

    SQL Server Python

  16. Wait for the program to install.

    SQL Server Installing

  17. Click <Close> on the Complete window.

    SQL Server Complete

Back to Top

SQL Server Management Studio (SSMS)
  1. Download SQL Server Management Studio.
  2. Click <Run> on the File Download - Security Warning.

    Download Security Warning

  3. Click <Yes> on the User Account Control prompt.

    UAC Warning

  4. Click <Install> on the User Account Control prompt.

    SSMS Install1

  5. Wait for the program to install.

    SSMS Install2

    SSMS Install3

  6. Click <Restart> if prompted to restart the computer or click <Close>.

    SSMS Complete

Back to Top

Allowing Access to the SQL Server from a Remote Computer

SQL Server Configuration
  1. Open the SQL Server Configuration Manager and click <Yes> on the User Account Control dialog.

    SQL Config. Manager

  2. Select SQL Server Network Configuration and Protocols for Instance Name.

    SQL Config. Manager Network

  3. Double-Click the TCP/IP protocol, change Enabled to Yes and click <OK>.

    SQL Config. Manager Properties

  4. Click <OK> on the Restart dialog.

    SQL Config. Manager Restart

Back to Top

3rd-Party Firewall
  1. Port:
    • Using a Named Instance: UDP Port 1434.
    • Using the Default Instance: TCP Port 1433.
  2. Program: 'C:\Program Files\Microsoft SQL Server\MSSQL14.Instance Name\MSSQL\Binn\sqlservr.exe'
  3. Program: 'C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe'
Back to Top

Windows Firewall
  1. Open the Windows Firewall with Advanced Security.

    SQL Server Firewall Menu

  2. Select Inbound Rules.

    SQL Server Firewall Inbound

  3. Select New Rule, Program, and click <Next>.

    SQL Server New Rule - Program

  4. Click Browse, navigate to 'C:\Program Files\Microsoft SQL Server\MSSQL11.Instance Name\MSSQL\Binn\sqlservr.exe', click <Open> and <Next>.

    SQL Server Program

  5. Click <Next>.

    SQL Server Action

  6. Click <Next>.

    SQL Server Profile

  7. Enter the name for the rule 'SQL Server' and click <Finish>.

    SQL Server Name

  8. Repeat steps #3 thru #7 but choose 'C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe' for the Program (step 4) and 'SQL Browser' for the Name (step #7).
  9. Select New Rule, Port, and click <Next>.

    SQL Server New Rule - Port

    • Using a Named Instance: Select UDP, Specific local ports, enter '1434' and click <Next>.
    • Using the Default Instance: Select TCP, Specific local ports, enter '1433' and click <Next>.

    SQL Server Port

  10. Click <Next>.

    SQL Server Action

  11. Click <Next>.

    SQL Server Profile

    • Using a Named Instance: Enter the name for the rule 'SQL Browser UDP Port 1434' and click <Finish>.
    • Using the Default Instance: Enter the name for the rule 'SQL Browser TCP Port 1433' and click <Finish>.

    SQL Server Port

Back to Top