help need for connection through internet

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

C#

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

Bala4 . V

Add a Solution

4 solutions

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)

Sarrrva · Answer 1 · 2012-12-30T20:23:00

hi visit this link,

http://stackoverflow.com/questions/7762204/a-connection-was-successfully-established-with-the-server-but-then-an-error-occ[^]

(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

Aarti Meswania · Answer 2 · 2012-12-30T19:41:00

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!
:)

Gordon Beeming · Answer 3 · 2012-12-30T21:49:00

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.

*Suvabrata Roy* · Answer 4 · 2012-12-30T19:36:00

Solution 1

Hi,

Please check you DB user name and password, I think those are incorrect.

Thanks
Suvabrata

Posted 30-Dec-12 19:36pm

Suvabrata Roy

v2

help need for connection through internet

4 solutions

Solution 3

Solution 2

Solution 4

Solution 1

Add your solution here

Preview 0