000032600 - How to change SQL Server default port in DLP Enterprise Manager 9.6

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000032600
Applies ToRSA Product Set: DLP
RSA Product/Service Type: Enterprise Manager
RSA Version/Condition: 9.6
Platform: Windows
 
IssueHow to change the port used for communication between the Enterprise Manager and the Database server
ResolutionOn the database server 
1- Run the SQL Server Configuration Manager.
2- Select the SQL Server Network Configuration.
3- Select from the list the instance you want to configure to listen to on a specific port.
4- To change the port assignment right-click on the TCP/IP protocol and select Properties.
5- Click on the IP Addresses tab.
6- Go down till the IPALL tab and change the TCP Port to the preferred new port number instead of 1433
7- You will have to restart the SQL server service
On the Enterprise manager server
1- Stop the EM service
2- Go to C:\Program Files (x86)\RSA\Enterprise Manager\webapps\root\WEB-INF\classes
3- edit application.properties
4- Add the port number to the below line 
 
jdbc.url=jdbc:sqlserver://SQLDB;;sendStringParametersAsUnicode=true;
integratedSecurity=true;selectMethod=cursor;encrypt=true;trustServerCertificate=true;databaseName=DLP_EM;

For example:
jdbc.url=jdbc:sqlserver://SQLDB:9999;;sendStringParametersAsUnicode=true;
integratedSecurity=true;selectMethod=cursor;encrypt=true;trustServerCertificate=true;databaseName=DLP_EM;

5- Start the EM service.

Attachments

    Outcomes