Microsoft SQL Server Installation

We recommend to use Microsoft SQL Server Enterprise/Standard edition, but keep in mind that it requires a license.

 

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.

Now we have to 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.

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

 

For safety purpose, we recommend to use a different user with necessary privileges:

1.Download MSSQL Server Management Studio and install it on 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 Security folder on the left-sided 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 Server Roles. From the Server roles list, choose sysadmin and keep checked public role. Click OK.

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