Answer The following steps are simple and generic. The intent of this article is to give you an idea of what you need to do.
Note:: The following steps are provided for informational purposes only. If you experience difficulty in implementing these steps, please contact Microsoft support for assistance.
1) Create an Alias using the Client Network Utility. Another approach is to create the reg key for this Alias:
You need to go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo and create a new string key. E.g. this key could be named MyPort. The reg key needs to have the following information:
DBMSSOCN, MyPort, the port number that you want.
DBMSSOCN, MyPort, 4455
2) Configure the default port that TCP/IP uses on the SQL Server Client Network Utility. If you open this utility and highlight TCP/IP under "Enabled Protocols by Order" and then select Properties you need to change the default port from 1433 to the new port number. This must be done along with the Alias that we had configured already. Once these two items were in place the NS could talk to the database host server over TCP/IP.
The following steps are simple and generic. The intent of this article is to give you an idea of what you need to do.