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.

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?