Advice and answers from the CareMonkey Team

The correct database port number is needed to completely set up the integration. If the administrator or the IT guy does not know which port your SQL Server is running on, this is a good time to find out. 

To do this, click "New Query" in the top left hand corner and copy the following query in the pane that will appear.

SELECT DISTINCT
 local_tcp_port
FROM sys.dm_exec_connections
WHERE local_tcp_port IS NOT NULL

Click "execute", and the port that your SQL Server is listening on will be displayed as below.

Did this answer your question?