sql server remote connection

Question

0.00/5 (No votes)

See more:

Hi friends
I create a sql server databse with sqlserver management studio and
use it in c# project by remote connection but by running
application following error appear

A network-related or instance-specific error occured while establishing
a connection to sql server

what's solution?

Posted 31-Dec-11 1:15am

Hekmat90

Updated 31-Dec-11 1:17am

Mehdi Gholam

v2

Add a Solution

Comments

Espen Harlinn 31-Dec-11 7:30am

You have to provide some information about your code/design - based on what you have provided we can only guess wildly ... for all I know you could be serializing the SqlConnection object from the server to the client ...

4 solutions

Solution 4

From link[^]:
Basically, when you failed to connect to your SQL Server, the issue could be:
1) Network issue,
2) SQL Server configuration issue.
3) Firewall issue,
4) Client driver issue,
5) Application configuration issue.
6) Authentication and logon issue.

Check these
Steps to troubleshoot SQL connectivity issues[^]
SQL Server 2005 Connectivity Issue Troubleshoot - Part I[^]
Troubleshoot Connectivity Issue in SQL Server 2005 - Part II[^]
Troubleshoot Connectivity Issue in SQL Server 2005 - Part III[^]

BTW check this bunch also for future errors

Posted 31-Dec-11 2:41am

thatraja

Comments

Espen Harlinn 31-Dec-11 8:46am

Checking these things out is a good start, my 5

Wendelius 2-Jan-12 3:31am

Good collection, 5

Solution 2

Recheck Your connection string and for more help follow the link
Connection String ^

Posted 31-Dec-11 1:27am

Vijay Kr Sharma

Comments

thatraja 31-Dec-11 14:12pm

No, only 4 for your answer, wrong connectionstring may be a case but what about other cases? check my answer

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)

Wendelius · Accepted Answer · 2011-12-31T01:26:00

Solution 1

Basically it means that the SQL Server is not responding. There are lots of possible reasons like, its not on, firewall blocking etc.

Have a look at for example this: http://www.sqlmusings.com/2009/03/11/resolving-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server/[^]

Posted 31-Dec-11 1:26am

Wendelius

Comments

Espen Harlinn 31-Dec-11 8:46am

5'ed!

Wendelius 2-Jan-12 3:30am

Thanks :)

thatraja 31-Dec-11 14:10pm

5!

Wendelius 2-Jan-12 3:30am

Thanks :)

RaviRanjanKr · Accepted Answer · 2011-12-31T02:10:00

Solution 3

Read thread from there-[A network-related or instance-specific error occurred while establishing a connection to SQL Server][^]
and this link-[A network-related or instance-specific error occurred while establishing a connection to SQL Server][^] might help you.

Posted 31-Dec-11 2:10am

RaviRanjanKr

Comments

Espen Harlinn 31-Dec-11 8:46am

5'ed!

RaviRanjanKr 31-Dec-11 9:00am

Thanks :)

thatraja 31-Dec-11 14:12pm

5!

RaviRanjanKr 31-Dec-11 16:23pm

Thanks :)

Wendelius 2-Jan-12 3:31am

Good links, 5'd

RaviRanjanKr 2-Jan-12 10:15am

Thanks :)