Microsoft SQL Server Installation

important

Important

We recommend using the Microsoft SQL Server Enterprise/Standard edition, but keep in mind that it requires a license. Microsoft SQL Server Express version is not supported by EEI.

Follow these steps:

1.After starting the MSSQL installer choose the Custom installation process.

2.You can keep the default installation path or choose a different one. Click Install.

3.After downloading the installation files, the SQL Server Installation Center appears. If not, start it up.

4.Choose the Installation menu from the left-side panel.

5.Choose New SQL Server stand-alone installation or add features to an existing installation to start the installation process.

6.Accept the License terms and click Next.

7.Select the check box to Use Microsoft Update to check for updates. Click Next.

8.In the Install Rules window, click Next.

9.In the Feature Selection window, select Database engine Services and SQL Client connectivity SDK check box. Click Next.

10.In the Instance Configuration window, you can keep the default value and click Next.

11.In the Server Configuration window, click Next.

12.In the Database Engine Configuration window, select the Mixed Mode option. Enter and confirm the password for the default "sa" user (SQL Server system administrator). You can use this user during the EEI Server installation process, or you can create a custom user with sufficient privileges (the steps are described in the last paragraph). Click Add Current User button. Click Next. Click Install.

Turn off/create firewall exception and enable TCP/IP communication for MSSQL to fully function EEI with MSSQL. Otherwise, the installation ends up with an error.

1.Open SQL Server Configuration Manager.

2.Click SQL Server Network Configuration in the left-side menu.

3.Click Protocols for MSSQLSERVER.

4.Make sure that the TCP/IP protocol is in status Enabled (should be by default).

5.Click SQL Server Services from the left-side menu.

6.In the right-side menu, right-click the SQL Server (MSSQLSERVER) service, and from the context menu, choose Restart.

7.Check the Windows Services that the SQL Server Agent is running. Otherwise, the EEI Server will not work.

Now is the MSSQL Server ready for the EEI Server to be installed.

 

For safety purpose, we recommend using a different user with the necessary privileges:

1.Download MSSQL Server Management Studio and install it on the MSSQL Server machine.

2.Log into the server. Server type: Database Engine, select the server name used on that server, Authentication: Windows Authentication. Click Connect.

3.Right-click the Security folder on the left-side menu. Choose New from the context menu -> Login.

4.Fill in Login name with your choice. Choose SQL Server Authentication. Fill in the Password and confirm it.

5.Deselect Enforce password expiration.

6.In the left-side menu of the same window, click on the User Mapping. From the list of users mapped to this login, choose a master and in the Database role membership list, choose db_owner and keep checked public role.

7.In the left-side menu, click on the Server Roles. From the server roles list, choose the dbcreator and leave the public checked.

8.Click OK.

Now you can proceed with the EEI installation with this new custom SQL user.

note

Note

As MSSQL is the most crucial part of the EEI server and can consume whole disk space, due to operating system stability, we recommend moving the MSSQL data and a temporary folder to the dedicated partition or to a separate server machine.

Follow these steps:

1.Run SQL Server Management Center.

2.In Object Explorer, right-click the name of the server.

3.In the context menu, click properties.

4.Select Database Settings from the left side menu.

5.In the Database Default Location, change the Data path.

 

When calculating required disk space, we are tracking three folders:

Database folder—The folder where MySql or SQL Server stores EEI database

Temporary database—The folder where MySql or SQL Server stores temporary tables

The EEI Server data folder—C:\ProgramData\ESET\EnterpriseInspector\Server folder

If the database is installed on the same machine as the EEI Server, then EEI stops accepting new events when:

There is less than 3% of free space on the disk with the database folder

There is less than 3% of free space on the disk with the temporary database folder

There is less than 5% of free space on the disk with the EEI Server data folder

If the EEI Server data folder and temporary database folder are on the same disk, EEI stops accepting new events if there is less than 10% of free space on this disk

If the database is located on the same machine as EEI, there has to be at least 10% free disk space where the temporary folder is for the Purge to be working. Any problems with the database purge are displayed as red markers on the Events processed chart on the Events Load Dashboard’s tab.