Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# SQL-Server
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
 
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
Edited 28-Dec-12 20:18pm
v2
Comments
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: http://blogs.msdn.com/b/sqlprogrammability/archive/2008/05/27/sql-server-intermittent-connectivity-issue.aspx

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 Maciej Los 245
1 OriginalGriff 210
2 Manfred R. Bihy 190
3 CHill60 180
4 _Amy 155
0 OriginalGriff 7,445
1 Sergey Alexandrovich Kryukov 6,157
2 Maciej Los 3,774
3 Peter Leow 3,448
4 CHill60 2,702


Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 29 Dec 2012
Copyright © CodeProject, 1999-2014
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