Not able to connect to SQL Instance on port other than 1433, when trying to install Dynamics 365 {CRM Tips from the Vault}

Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com
CRM tips from the vault – A series which I have started on request of my blog readers who are quite new to CRM. My blog focus on niche topics which mostly require a prior in-depth understanding of Dynamics 365. However in this series I will mostly cover the topics which are quite simple, used in almost every project implementations and more importantly have withstood the test of time.
Here is my Tip 6 – How to connect to SQL instance on port other than 1433 when trying to install Dynamics 365 on-premise?
Well this one will be pretty quick. But this is one of the issues if you are not aware of it, it can take out few hours of your valuable time. While it is a tip from the days of on-premise Dynamics CRM, it is applicable even today if you try to install Dynamics 365 on-premise.
Usually when you install Dynamics CRM, you will connect to SQL on the default port 1433. While it is recommended to use the default port 1433 for installation, sometimes you may need to connect to a SQL instance hosted on some other port.
Say I need to connect to SQL server instance hosted on port 1468. So in the CRM set-up wizard, you need to provide the SQL connection string in the following format
SERVERNAME\INSTANCENAME, 1468
If the port number is 1433, you don’t need to specify the port name.
Once you use this, you should be successfully able to connect you CRM instance and proceed with the installation.
Hope this helps!
Debajit Dutta
(Business Solutions MVP)