SQL SERVER ERROR 40 in C#

Question

0.00/5 (No votes)

See more:

I have done Krypton project in VS 2010. And there is a data base which created in MSSQL 2005 express. The project has several data grid views and data sets. I have displayed Some data using data grid view using data sets without any coding just configure the data grid view. My project is working. but when i created a setup file using inno setup software and create the data base in another pc and run that setup file and installed it some interface are working but interfaces which contain data grid view dosent display and it displays

 "An error has occurred while establishing a connection to the server when connecting to SQL server 2005, this failure may be caused by the fact that under default settings SQL server does not allow remote connection. ( provider: Named Pipes Provider, error: 40 – could not open a connection to SQL server. "

Please help me i'm in a big trouble. I should finish this assignment. :(

i searched this error in internet ant have done lot of configurations but still couldn't fix it. give me some solution.

Posted 1-Jun-12 8:07am

Member 7980534

Updated 1-Jun-12 10:36am

Maciej Los

v2

Add a Solution

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)

Maciej Los · Answer 1 · 2012-06-01T10:38:00

Solution 2

Please, have a look here: Named Pipes Provider, error 40...[^]

Posted 1-Jun-12 10:38am

Maciej Los

Comments

VJ Reddy 5-Jun-12 19:56pm

Good reference. 5!

Maciej Los 6-Jun-12 9:16am

Thank you, VJ ;)

Tim Corey · Answer 2 · 2012-06-01T08:14:00

Solution 1

Basically, it sounds like you have not enabled Named Pipes on your SQL Server database. Here is an article that will tell you how to do so:

http://geekswithblogs.net/TimH/archive/2006/01/30/67586.aspx[^]

Posted 1-Jun-12 8:14am

Tim Corey