The "non-standard port" creates a challenge for SharePoint Administrators and the SharePoint Installation. The SharePoint installation is looking for SQL Server on the Standard Port (1433).
An option that I've used and found to be very effective is the creation of a SQL Server Alias on each server in the farm. It's never bad, in my opinion to alias your SQL Server connection. You never know when this will be helpful in the future, specifically in the case of a database migration or hardware refresh.
Steps to create a SQL Server Alias:
- Open SQL Server Client Network Utility. (I believe this tool is native to Server 2003, 2008 and 2008 R2).
- Click on the Alias tab
- Click Add
- Server Alias: "Enter the Alias information (eg. "SPDatabase")
- Network Libraries: TCP/IP
- Server Name: "Enter the name of the SQL Server you where the Databes will be hosted"
- Dynamically Determine Port: "Uncheck to enter a specific port, or leaved checked to dynamically determine port
You'll need to recreate these steps on all the servers in the farm.