How to select a port to connect to SQL-Server Remote

Asked

Viewed 849 times

2

I have the following problem, my SQL server is with port 1433 open and communicating correctly, but my client has a firewall that blocks all incoming and outgoing ports of computers connected to the network. Here comes the problem, I need to connect to this server but I can not find where I can choose which port I will use. In addition, by checking the open ports on a computer, connected on another network, connected to the server, I verified that they are dynamic and I do not have the possibility to unlock all the ports of my client. Does anyone have any idea how to proceed? I didn’t post any code because I couldn’t find anything I could change in mine connectionString or in my SqlConnection.

tldr: My SQL-Server has all ports open, but my client has all ITS ports closed, as I choose which ports my client will use to connect to on my port 1433 server?

asp.net sql-server

  • For free, there is another terminal in the client that can access your SQL Server server ?

  • No, all the machines have all the doors locked, just the ones they open specifically. The way will be to use a 3G connection for this I think, since the company does not want to open all the doors to a station only ( I would concentrate all the bank requests there, creating a Webservice and accessing it through their own network).

1 answer

2

In his connectionString, puts a comma after the IP/server. For example:

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

Thus, you are specifying exactly the port to container. Now, if the customer has all locked doors, you will have to invent another type of solution.

Browser other questions tagged asp.net sql-server

You are not signed in. Login or sign up in order to post.