Click here to Skip to main content
13,506,535 members
Rate this:
Please Sign up or sign in to vote.
See more:
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

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
Updated 28-Dec-12 20:18pm
Plyswthsqurles 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:

1 solution

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web04 | 2.8.180417.1 | Last Updated 29 Dec 2012
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100