Install SQL Server

Version 43.1 by Niklas Palmgren on 2019/03/28 09:19

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:

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:
Copyright 2024 StruSoft AB
IMPACT Wiki