Click here to Skip to main content
11,496,146 members (499 online)
The site is currently in read-only mode for maintenance. Posting of new items will be available again shortly.
See more: C# SQL-Server
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 16:16pm
Edited 28-Dec-12 21:18pm
Plyswthsqurles at 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ő at 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
0 Sergey Alexandrovich Kryukov 10,401
1 OriginalGriff 8,910
2 Sascha Lefèvre 3,899
3 Maciej Los 3,422
4 Richard Deeming 2,600

Advertise | Privacy | Mobile
Web03 | 2.8.150520.1 | Last Updated 29 Dec 2012
Copyright © CodeProject, 1999-2015
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