We have a SQL 2000 installation running on port 1306 as we also have SQL 2005 on port 1433.
We have found this by checking the "Server Network Utilities" program. We've also disabled "name pipes" on the enabled list as we're not using it and have TCP/IP enabled
We've configured the external firewall to allow traffic over this port and forward it to the host machine's ip address.
So the question is, how do we configure the connection string and are we missing a step in setting up the SQL server to cope with this.
Currently whilst trying to add a sql server registration from outside our firewall we're using our external ipaddress followed by the port nuber. xxx.xxx.xxx.xxx:1306
Help is much appreciated. Thanks.
Start Free Trial
