How to configure RSA NW Endpoint (Windows Version) when MSSQL Port has been changed

[#1]

Article Number

000001096

Applies To

RSA Product Set: NW Endpoint
RSA Product/Service Type: NW Endpoint
RSA Version/Condition: 4.4.x
Platform: Windows
Platform (Other): MSSQL Database
Product Name: RSA NetWitness Endpoint
 

Issue

How to change the default port that is used by ECAT UI and Console server that is used to connect to the database.
The default port that is used is 1433. At times, it might be a requirement to change TCP port after NW Endpoint has been installed.

 


 

Resolution

1. On the Endpoint (ECAT) Console server go to C:\Program Files\RSAECAT\Server and find ConsoleServer.exe.config. Look for the following lines:

<add key="RemoteSqlServer" value="hostname,port"></add>

2. Change the port number in the line to what the database is configured to use.
3. Repeat the same steps as above for the APIServer.exe.config. This file is also located in the C:\Program Files\RSAECAT\Server folder.
4. Go into the Endpoint (ECAT) UI, under Connections. Add the new port to the end of the Database Server Name field.

Note: The port number has a comma between the database server name and the port. (Example: databaseserver, 1234)