Connect to a MS SQL database with the Enterprise Manager by using port

Some Internet Service Providers block SQL's default port 1433. Alternatively, connections are also allowed through Port 11433.

To configure an alternate port on your local machine, open up the "SQL Client Network Utility". Under the "General" tab, there is a listing of the Enabled Protocols. Select "TCP/IP" and click on the "Properties..." button. Here, you'll see 1433 listed as the "Default port". Change this to 11433 and click the "OK" button. Click on "Apply" button in the main window, then "OK" to close the Client Network Utility. You can then connect to your remote SQL database using the alternate port.

ISPs can block port 1433 to protect their networks against abuse, virus attacks, etc. By providing customers with an alternate method of connecting to their databases, customers the opportunity to use the tools and services then need for the highest level of management of all aspects of their sites.

Add Feedback