Port Forwarding in router for remote connection

Question

0.00/5 (No votes)

See more:

Hi:
My server is sql 2008 which is in my head office and i have developed a C# Windows application
I want to connect my office server from Branch using the application
i have port forwarded the router where sql server is installed, but when i connect from server from branch office it throws the following error

i have tried this using management studio also but i got the same error

SQL

a connection was successfully established with the server but then an error during login process. (Provider: TCP Provider, Error :0 - the specifed network is no longer available.) (Microsoft sql Server , error:64)

Posted 28-Dec-12 15:16pm

Bala4 . V

Updated 28-Dec-12 20:18pm

v2

Add a Solution

Comments

David_Wimbley 29-Dec-12 0:30am

1) Can you run a port scan on the network to make sure the port is open?

2) Another one that i run into often, try turning off windows firewall...if it works turned off you need to add a rule to windows firewall to allow 1433 through.

3) Is this 2008 r2 or 2008 express?

To me it seems as though its a timeout issue due to windows firewall but without seeing a full trace message i cant be sure exactly.

Zoltán Zörgő 29-Dec-12 3:17am

First of all, you need to figure out what kind of connection you have between offices, more exactly what is routed, and what is not routed (not only your rooter can be in between). Is it a leased line, a dial-in kind of direct connection, or both offices are connected on their own to the internet? Can you connect to anything in main office from the branch office?
Oh, and look around here: http://blogs.msdn.com/b/sqlprogrammability/archive/2008/05/27/sql-server-intermittent-connectivity-issue.aspx

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)

*Abhishek Pant* · Answer 1 · 2012-12-28T22:32:00

Solution 1

have a look at these..
http://social.msdn.microsoft.com/Forums/en/sqltools/thread/6dc64b47-cc64-4942-90f8-242c47eee511[^]

http://havardkristiansen.com/?p=315[^]

Posted 28-Dec-12 22:32pm

Abhishek Pant