1. Download the SQL Express 2014 and SQL Management Studio. Since it will be installed on the same server as Deep Security, download the 64-bit version of SQL Express installers.
2. Execute the SQLEXPR_x64_ENU setup file.
3. Choose a temp folder for the extracted files.

   

4. Select the New SQL Server stand-alone installation option.

   

5. Tick I accept the license terms check box and click Next.

   

6. Check the Use Microsoft Update to check for updates (recommended) option to prevent security vulnerabilities in SQL Express.

   

7. Tick the Database Engine Services as the only component to be installed, and then modify the installation path for the customer environment.

   

8. Specify the instance for SQL Express. It is recommended to create a new one for Deep Security.

   

9. Set the Startup Type of SQL Browser Service to Automatic.

   

10. Choose the Mixed Mode radio button and set a password for the system administrator (SA) account. Make sure to select a windows account as the SQL Server Administrator.

    

11. Click Close to complete the SQL Express 2014 installation, and then exit the installer.

    

1. Execute the SQLManagagementStudio_x64_ENU setup.
2. Specify a temp folder for the extracted files.

   

3. Choose the New SQL Server stand-alone installation.

   

4. Select the Perform a new installation of SQL Server 2014 radio button.

   

5. Check the I accept the license terms and click Next.

   

6. Tick only the Management Tools - Basic and click Next.

   

7. Click Close to complete the installation, and then exit the SQL Express installer.

   

1. Open the SQL Configuration Manager.

   

2. Expand SQL Server Network Configuration and select protocols for your SQL Express Instance (e.g. Protocols for DEEPSECURITY).

   

3. Right-click TCP/IP and choose Enable to activate the TCP/IP Connectivity.
4. Click OK to acknowledge the requirement for the service restart.
5. Go to SQL Server Service.
6. Right-click the SQL Server Service for your installed instance and click Restart to enable the TCP/IP configuration.
7. Close the SQL Configuration Manager.

If the TCP Dynamic Ports is configured, Deep Security Manager may fail to connect to the database, follow the steps below to resolve the issue.

1. In the MS SQL Server Manager, enable TCP/IP.
2. Confirm the correct TCP addresses.
3. Remove any entry in TCP Dynamic Ports field.
4. Add 1433 to TCP Port field.

   

1. Open SQL Management Studio and log in to your instance using the system admin account you created during installation.

   

2. Right-click Databases and select New Database.
3. Enter the database name and click OK.

   

4. (Optional) You may create an SQL Service Account for Deep Security.
   1. Expand Security and right-click Logins, then select New Login.
   2. Enter the Login Name.
   3. Select SQL Server authentication.
   4. Set a password and confirm the password for the service account.
   5. Untick the Enforce password expiration option. This should also disable the User must change password at next login checkbox.
   6. From the Default Database drop-down, select the database name you created in Step 3.

      

   7. Click User Mapping and select the database created from the previous steps.
   8. Tick the db_owner role for the database.
5. Click OK and close the SQL Configuration Manager.

1. Run the setup file and select a language.

   

2. On the Welcome page of the Deep Security Manager Setup Wizard, click Next.

   

3. Accept the license agreement and click Next.

   

4. Specify the installation path and click Next.

   

5. Configure the database server.
   1. Select Microsoft SQL Server.
   2. Type a host name for the SQL Express.
   3. Choose TCP as the transport.
   4. Specify a username and password for the database.

   

6. Click Advanced and specify the Instance name if you are using a Named Instance of SQL Express.

   

7. Click Start Readiness Check to assess the system where you are installing. The setup wizard will display a warning on using SQL Express database.

   

8. Click Install Deep Security Manager.

   

9. Enter the Activation Code and click Next.

   

10. Verify the Manager address and port details, and then click Next.

    

11. Provide the Username and Password for the web console, and then click Next.

    

12. Make sure the Create Scheduled Task to regularly check for Security Updates checkbox is enabled.

    

13. Confirm to install the relay-enabled agent and click Next.

    

14. Make sure the option Enable Trend Micro Smart Feedback is ticked, and then click Next.

    

15. Click Install to proceed with the Deep Security Manager installation.

    

After the installation, note that the DSM will show a notification stating that the SQL Express database is not supported for production deployments.