When creating a project that will use SQL Server as the back end, the default port used is 1433. You need to have your firewall and router forwarding incoming requests on that port. However, if you need to use a different port, you need to specify it in your string. The way you do that is in the IP setting. Where you would type IP=99.999.999.99 for a specific port you type IP=99.999.999.99,5000. The comma after the IP address separates the IP from the Port assignment. The port can be assigned after the comma.
Specific Port in Connection String to SQL
This entry was posted in Access 2007 problems/solutions, Uncategorized and tagged SQL Server Ports; VBA Connection string to SQL Server. Bookmark the permalink.