How to install Microsoft SQL Server 2017 Express Edition and SQL Server Management Studio (SSMS). Video also shows how to configure TCP/IP settings for port 1433.

  1. Download and install Microsoft SQL Express Edition
    • The ‘PolyBase Query Service for External Data’ is not required to be checked
    • The ‘Named instance’ will be your database name
    • Ensure the ‘Grant Perform Volume Maintenance Task privilege to SQL Server Database Engine Service’ is checked
  2. Download and install SQL Server Management Tools (SSMS)
  3. SQ: Server Configuration Manager
    • Open SQL Server 2017 Configuration Manager
      • SQL Server Network Configuration
        • Protocols for SQL Server
          • Ensure TCP/IP properties are enabled
        • IP Addresses
          • IPAll
            • TCP Port
              • Type ‘1433’
                • Click okay and save changes
  4. Restart windows

Microsoft SQL Server 2017 Express Edition and SQL Server Management Studio (SSMS) will now be installed on your device.

Return to support