db connection problem error occur

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

my connection string giv en below

C#

<add name="ConnectionString" connectionString="Server=182.50.151.49;Database=AnbU12_pro;User ID=***;Password=***;Trusted_Connection=False;" providerName="System.Data.SqlClient"/>


Error Msg :

<pre lang="C#">A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)</pre>

Posted 18-Dec-15 1:11am

Member 10493886

Updated 18-Dec-15 1:49am

AnvilRanger

v2

Add a Solution

Comments

AnvilRanger 18-Dec-15 7:50am

I updated your question to remove the user is and password. You should never publish information like that in a public forum.

2 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)

aarif moh shaikh · Accepted Answer · 2015-12-18T01:21:00

First of all . Check your server (182.50.151.49) working or not .
if the server is working fine than check sql Server Service. (is running or not).

Second think is :
Make sure your database engine is configured to accept remote connections:

For more details about your problem . please follow below link .

http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/[^]

http://stackoverflow.com/questions/18060667/why-am-i-getting-cannot-connect-to-server-a-network-related-or-instance-speci[^]

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.[^]

Regards,
AARIF SHAIKH

Naveen.Sanagasetti · Accepted Answer · 2015-12-18T02:24:00

Solution 2

I too agree with aarif post, if the server is not working you can't able to open the database and execute the scripts over there. I suggest you to check with your system team to resolve network related issue first and then recheck again.

Posted 18-Dec-15 2:24am

Naveen.Sanagasetti