Microsoft SQL Server Installation

Follow these guidelines when installing different versions of Microsoft SQL Server:

You may need to setup your firewall to open TCP port 1433 and UDP port 1434 to enable remote access to the database server.

1. Microsoft SQL Server 2017

  1. Run SQL Server installation program with default options except when noted below.
  2. Check 'Database Engine Services' and 'Client Tools Connectivity' check boxes on the 'Feature Selection' page.
  3. Change 'Startup Type' of the 'SQL Server Browser' service to 'Automatic' on the 'Server Configuration' page.
  4. Select 'Mixed Mode' radio button on the 'Database Engine Configuration' page.
  5. Type in a new system administrator (sa) logon password on the same page.
  6. Add a SQL Server administrator account on the same page.
  7. Finish the installation.
  8. Recommend:  Install SQL Server Management Tools; SQL Server Management Studio option. – (not required, but is needed for in house setup/testing)
  9. Download and install Microsoft SQL Server 2005 Backward Compatibility Components. – (this now takes you to the Feature Pack download page. After clicking the download button, select the SQLServer2005_BC_x64.msi package to download the Backward Compatibility Pack.)
    Disable all the features except 'SQL Distributed Management Objects' during installation.
  10. Copy Microsoft C Runtime and Microsoft DB-Library redistributables into Windows\SysWOW64 directory.