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. SQL: 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 computer. You are now ready to archive data using Microsoft SQL server

Return to support