Install SQL Server

Last modified by Linus Karlsson on 2019/05/28 11:10

Overview

Microsoft SQL Server is available in different editions where functionality varies slightly depending on the price tag. You can read about these different editions here. We recommend that you at least use the standard version. Unlike the Express version, it has no significant limitations that could affect the performance of IMPACT. For supported versions please refer to StruSoft installer.

It is possible to purchase SQL server standard edition through us at a reduced price, against the restriction that it can only be used with IMPACT and no other software. Please visit StruSoft.com to find your local IMPACT provider for consultation. 

Installation

This chapter will guide you through the installation of MS SQL Server. 

Installation packages:

Documentation from Microsoft:

Configure the firewall to allow access

Allow traffic through the firewall:

The default ports that are used for IMPACT are listed below

  • 1433 - allows communication between Web API and SQL database (TCP)
  • 1434 - allows communication between Web API and SQL database (UDP)
  • 81 - allows communication between client, Web API and Open ID (TCP)
  • 8090 - used to access the web interface for the license server (TCP) 
  • 55555 - used for accessing licenses (TCP)
  • 27000-27009 used for accessing licenses (TCP)

Configure server authentication

To make it possible for IMPACT to communicate with the database through our web services (API and security server), the SQL server must allow SQL server authentication. This can be configured in SSMS (SQL server management studio) as shown in figure 1 and 2.

SQL server properties.png

Figure1: Server properties

1528724796914-616.png

Figure 2: Server properties - Server Authentication mode


Continue with the installation: Create an IMPACT database!

Tags:
Created by Niklas Palmgren on 2018/07/17 11:01
Copyright 2018 StruSoft AB
Impact Documentation