Wiki source code of Install SQL Server

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

Show last authors
1 (% class="row" %)
2 (((
3 (% class="col-xs-12 col-sm-8" %)
4 (((
5 = Overview =
6
7 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>>https://www.microsoft.com/sv-se/sql-server/sql-server-2017-editions]]. We(% class="mark" %) 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.
8
9 (% class="box infomessage" %)
10 (((
11 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>>https://strusoft.com/products/impact]] to find your local IMPACT provider for consultation.
12 )))
13
14 = Installation =
15
16 This chapter will guide you through the installation of MS SQL Server.
17
18 Installation packages:
19
20 * [[Download SQL server>>https://www.microsoft.com/sql-server/sql-server-editions-express]] (express edition)
21 * [[SQL server management studio>>https://docs.microsoft.com/sql/ssms/download-sql-server-management-studio-ssms]]
22
23 Documentation from Microsoft:
24
25 * [[Plan your installation>>https://docs.microsoft.com/sv-se/sql/sql-server/install/planning-a-sql-server-installation?view=sql-server-2017]]
26 * [[Installation wizard help>>https://docs.microsoft.com/sv-se/sql/sql-server/install/instance-configuration?view=sql-server-2017]]
27
28 == Configure the firewall to allow access ==
29
30 Allow traffic through the firewall:
31
32 (((
33 * [[Configure the firewall to allow access>>https://docs.microsoft.com/sv-se/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-2017]]
34 * [[Ports used by SQL server>>https://docs.microsoft.com/sv-se/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-2017#ports-used-by-]]
35
36 The (% class="mark" %)default(%%) ports that are used for IMPACT are listed below
37
38 * 1433 - allows communication between Web API and SQL database (TCP)
39 * 1434 - allows communication between Web API and SQL database (UDP)
40 * 81 - allows communication between client, Web API and Open ID (TCP)
41 * 8090 - used to access the web interface for the license server (TCP)
42 * 55555 - used for accessing licenses (TCP)
43 * 27000-27009 used for accessing licenses (TCP)
44 )))
45
46 == Configure server authentication ==
47
48 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.
49
50 [[image:SQL server properties.png]]
51
52 //Figure1: Server properties//
53
54
55 [[image:1528724796914-616.png]]
56
57 //Figure 2: Server properties - Server Authentication mode//
58
59 ----
60
61 Continue with the installation: [[Create an IMPACT database!>>doc:Installation.Create an IMPACT database.WebHome]]
62 )))
63
64 (% class="col-xs-12 col-sm-4" %)
65 (((
66 (% class="box" %)
67 (((
68 [[image:Wiki article - Install SQL Server.svg]]
69 )))
70
71 (% class="box" %)
72 (((
73 **Contents**
74
75 {{toc/}}
76 )))
77 )))
78 )))
Copyright 2018 StruSoft AB
Impact Documentation