How to select a port to connect to SQL Server Remote

2

I'm having the following problem, my SQL server is with port 1433 open and communicating properly, but my client has a firewall that blocks all the incoming and outgoing ports of the computers connected on the network. Here comes the problem, I need to connect to this server but I have not found where I can choose which port I'm going to use. Also, checking the open ports on a computer, connected to another network, connected to the server, I verified that the same are dynamic and I do not have the possibility to unlock all the ports of my client. Anyone have any idea how to proceed? I did not post any code because I did not find anything where I could change in my connectionString or my SqlConnection .

My SQL Server has all ports open, but my client has all its ports closed, how do I choose which ports my client will use to connect to my port 1433 from the server?

    
asked by anonymous 30.05.2014 / 00:16

1 answer

2

In your connectionString , put a comma after the IP / server. For example:

<connectionString Server="128.0.0.1,6000" ... />

So you're specifying the exact port to connect to. Now, if the client has all blocked ports, you'll have to devise another kind of solution.

    
03.06.2014 / 20:07