Which version of SQL Server are you using?

How to install Microsoft SQL Server 2019 on-premises edition and SQL Server Management Studio (SSMS)

    1. Download and install Microsoft SQL Server 2019 on-premises
      • After download, select ‘Run’
    2. Select ‘Custom Installation’
      • Install it under your preferred location
    3. In the SQL Server Installation Center, select ‘Installation’ on the left side bar
      • Select ‘New SQL Server stand-alone installation or add features to an existing installation’
      • If you have a product key, enter it now. Otherwise select the ‘Evaluation’ free edition
      • After agreeing to the terms and conditions, ensure that ‘Use Microsoft Update to check for updates’ is checked
      • In Feature Selection, ensure Database Engine Services is checked
      • In ‘Server Configuration, ensure SQL Server browser is set to ‘Automatic’ under ‘Startup Type’
      • In Database Engine Configuration, select ‘Add Current User’
      • Select ‘Install’
    4. After install, in the SQL Server Installation Server under Installation, select ‘Install SQL Server Management Tools
      • Download ‘Sql Server Management Studio (SSMS)’
      • Select ‘Run’
      • Select the location you with to download it to and click install
    1. Restart Windows

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 OPC Support