Allow sql server 2008 r2 port cross public IP

Question

1.00/5 (1 vote)

See more:

Hi All

I am a software developer. I work with C#.net and microsoft sql server 2008r2.
Now i have a problem with microsoft sql server 2008 r2 can not connect from anywhere has internet.
I have a public IP and public IP configure in tp-link router.
and my database store in a computer which connect to the router and this computer can also use internet too.
In the router I use forward IP to this computer and i have set the static IP to this computer already.

So the problem is I can not connect this database in this computer over the internet.
i google much times but still have no the solutins.

Please help me!

Thanks

Posted 13-Aug-13 23:00pm

HI_Friend

Add a Solution

Comments

David_Wimbley 14-Aug-13 9:54am

So i have a few questions.
1) Do you have access to the Sql box when you are on the same network as that Sql machine? If yes...good.
-If you don't have access to the Sql box on the same network i would check your windows firewall.
2) If you have access to Sql box on same network, what port did you use to port forward your machine through your router? 1433 i believe is what you should use by default, otherwise if you've changed the default port number you need to make sure it is reflected as such in your router.
3) Then another way to test connection is by using telnet. On a separate network from your sql box, see if you can telnet to your ip:1433...so (98.999.9.1:1433). If telnet doesn't crap out, it is listening. You could also do a port scan on your static IP address to see what ports are open/listening.

If you see 1433 is open listening then you've got to provide some error messages as to what is going on. Either that or check your event log. But hopefully this will steer you in some path towards a resolution.

HI_Friend 15-Aug-13 2:24am

Thanks for your reply

I'm not yet test with the same network because i have only one computer.
Now i'm very busy with my work so let ask you later.
And I will test it at the same network before i ask you again.
Thanks

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)

Member 9549287 · Answer 1 · 2013-08-14T13:35:00

Solution 1

If you're using Windows 7 or later, you need to allow sql server through the firewall. Most programs are blocked by default on installation. To allow the database engine services, configure windows firewall for database access

Posted 14-Aug-13 13:35pm

Member 9549287