How to get data from SQL database with closed port 1433

Question

1.00/5 (1 vote)

See more:

Normally I use port 1433 or 1434 for connection to database. In this situation I am not allowed to open port but I am allowed to install windows services or other type of service on that server. Please, I don’t know a lot about services and communication between web application and services. Moreover, Ip address of sql server is not static but changes one or two time per year and I have to get some images from folder on the server as well.
Could somebody help me what is the best solution?
To add. They said that thay don't have password to change setting of router. I wrote windows service which accessed to database and got external Ip address and wrote it to log (for testing purpose). Do I need specific port for communication with this service? What is the easiest way of communication between web application and the service? Do I need WCF service or something else?

Thanks,
Bobo

Posted 5-Jul-15 9:14am

Member 11563219

Updated 5-Jul-15 10:40am

v2

Add a Solution

Comments

[no name] 5-Jul-15 15:32pm

The best solution for you would be to talk to your network admin and find out what they can do to enable you to do your job.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Accepted Answer · 2015-07-05T10:18:00

Solution 1

Talk to your network admins about it.

Either they open the ports so your code can talk to the SQL Server or they have to give you some options.

Posted 5-Jul-15 10:18am

Dave Kreskowiak