Configuring Arcot Database on a port other than 1433 SQL Server

Document ID : KB000014278
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

During installation we are trying to install CA Advanced Authentication with sql server database on port 1441 and it is unable to connect to the database during the test connection. Can we connect arcot to the arcot database on a port other than 1433.

Environment:
Any SQL server, Any Webfort on any OS
Answer:

1433 is the default SQL server Port for databases. In order to use another port to connect arcot to arcot database on SQL server, you need to change the PORT on the "SQL server Connection Manager".

 

1)Go to SQL server Connection Manager

2) Expand "SQL Server Network cONFIGURATION". Under here click "Protocols for MSSSQLSERVER. 

3) A dialog box will open and here you can change the PORT. 

4) After changing the POST in above steps, use this new port when installing arcot.