Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# SQL
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 30-Dec-12 19:33pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

hi visit this link,
 
^]
 
(or) read this
 
Error Message:
 
The specified network name is no longer available.
 
Explanation:
 
The network resource that you specified was either temporarily taken offline or is no longer available. It is possible that: (1) the share at the server might have been temporarily deleted; (2) the server that shared the resource might have been turned off; or (3) the permissions might have been changed.
 

regards
sarva
  Permalink  
v3
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Hi,
 
Please check you DB user name and password, I think those are incorrect.
 
Thanks
Suvabrata
  Permalink  
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

step 1: follow steps given in this link to setting up database on server pc
http://support.microsoft.com/kb/914277[^]

step 2: after step 1 complete then change connection string's parameters,
datasource = server-name OR IP-Address [which is in sharing now after step 1] ; [For ip address cmd > ipconfig -it will show ip address]
Initial catalog = your database name ;
UserId = sql server - user login Id ;
Password = sql server - user login password;
 
Happy Coding!
Smile | :)
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 4

I know it's not quite what you are asking but have you thought of developing a web application that hosts web services that sits in the same enviroment as your SQL instance instead of connecting directly to the SQL instance from th client?, Connecting directly could be a security risk.
 
You can then have your web application connecting directly into SQL which will give you less problems and will be more secure.
  Permalink  
v2

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

  Print Answers RSS
0 mhegazy94 460
1 Sergey Alexandrovich Kryukov 460
2 Ravi Bhavnani 190
3 Kornfeld Eliyahu Peter 185
4 Shemeemsha RA 160
0 Sergey Alexandrovich Kryukov 7,135
1 OriginalGriff 6,801
2 CPallini 5,350
3 George Jonsson 3,619
4 Gihan Liyanage 2,797


Advertise | Privacy | Mobile
Web02 | 2.8.140922.1 | Last Updated 31 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