Installing SQL Server

When using the Express setup type to install Sentinel LDK-EMS, you have the option to first install SQL Server manually on the machine where you will install Sentinel LDK-EMS.

When using the Advanced setup type, an SQL Server must already exist and must be active, either on the local machine or on a different machine.

If you install SQL Server manually, you can install any of the supported versions of SQL Server.

NOTE   The Express editions of Microsoft SQL Server provide a maximum relational database size of only 10 GB. For details, see Sentinel LDK Release Notes.

To install SQL server, use one of the following methods:

>Install the SQL Server instance using a command prompt (silent installation). For example: For SQL Server Express 2019, use:

SQLEXPR_x64_ENU.exe /q /IACCEPTSQLSERVERLICENSETERMS /ACTION=Install /FEATURES=SQL /INSTANCENAME=EMSDATABASE /SAPWD=DBA!sa@EMSDB123 /SQLSVCSTARTUPTYPE=Automatic /SECURITYMODE=SQL /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /TCPENABLED=1

For other versions of SQL Server, the syntax of the installation command may be different.

Installation software for SQL Server Express 2019 can be found in the Sentinel LDK installation package, under: \Windows\3rdparty\MSSQLExpress2019\

>Install the SQL Server instance using a normal installation, and specify the following:

a.(For the Express setup type) Specify the instance Name as: EMSDATABASE

b.Select the mix mode installation. (Windows authentication and SQL Authentication)

The password for the sa user is as follows:

>For the Express setup type: The password for the sa user must be: DBA!sa@EMSDB123

>For the Advanced setup type: The password for the sa user should not contain any characters from a non-English language. (Numbers and special characters such as !,@ and # are allowed.)