How to change SQL Server default port in DLP Enterprise Manager 9.6
2 years ago
Originally Published: 2016-02-22
Article Number
000065110
Applies To
RSA Product Set: DLP
RSA Product/Service Type: Enterprise Manager
RSA Version/Condition: 9.6
Platform: Windows
 
Issue
How to change the port used for communication between the Enterprise Manager and the Database server
Resolution
On 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.

Related Articles

Trending Articles

Don't see what you're looking for?