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.Choose Developer edition in the Specify a free edition drop-down menu. Click Next.

7.Accept the License terms and click Next.

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

9.In the Install Rules window, click Next.

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

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

12.In the Server Configuration window, click Next.

13.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). Keep in mind that you are going to use this user during the EEI Server installation process. 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.