Solved

Named pipes provider error 40, but only for other users!

Posted on 2009-05-07
12
306 Views
Last Modified: 2012-05-06
I have a winforms app in VB.NET 2008 with a SQL Server 2008 back end on an internal server on our network.  There is no firewall on the server as it is not exposed to users outside the network.  The software has worked great until this morning.  I checked and found that the server had been rebooted due to some 'upgrades' and then it connected to the network again.

The software works perfectly for me, but my two other users get the error in the attached screen shot.  I have tried all day to troubleshoot the issue to no avail.  I have disabled shared memory, I have disabled named pipes, I have gone back and enabled both.  Any ideas?
ErrorMessage.doc
0
Comment
Question by:pigparent
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
  • 2
12 Comments
 
LVL 15

Expert Comment

by:mohan_sekar
ID: 24330035
Try this - if you are accessing the server by it's name, try by it's IP address.
0
 
LVL 1

Author Comment

by:pigparent
ID: 24330091
Good suggestion though my connection string refers to it by IP address.  I wouldn't know a named pipe from a sewer pipe, frankly.
0
 
LVL 15

Assisted Solution

by:mohan_sekar
mohan_sekar earned 75 total points
ID: 24330199
And the others also refer to it by IP address?

One other way I could think of is creating an alias as below

Open SQL Server Configruation Manager, right click on 'Aliases' and select 'New Alias'. Enter alias name, port # of your DB server, protocol (TCP/IP) and server name.
Restart your program and see if it helps
0
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 
LVL 70

Assisted Solution

by:Qlemo
Qlemo earned 75 total points
ID: 24330318
If there are some issues with TCP, like name resolution problems (does not apply if you use IP addresses, as you told us), delays in establishing connections, and alike, Named Pipes are (tried to be) used even if they are disabled on client and/or server side. Named Pipes cannot be established using IP addresses, only with (NetBIOS) names.

If you can't get around the cause, which is always a network issue, use the workaround to allow Named Pipes, and connect with name instead of IP.

0
 
LVL 1

Author Comment

by:pigparent
ID: 24334953
Thanks to both of you.  I have tried both suggestions and neither has worked.  I stepped through the code and replaced my username with theirs and it worked fine on my machine.  Only when I had one of the users log into my machine and I stepped through the code did I get the error shown in the screenshot.  Could it be a user account issue?  Something installed on my machine that's not present on theirs...or vice-versa?  Thanks!
0
 
LVL 70

Expert Comment

by:Qlemo
ID: 24335484
This smells like missing access rights for Named Pipes, which are done by a similiar technique as file shares. If those users would be admins, it will work, if I'm right.
0
 
LVL 1

Accepted Solution

by:
pigparent earned 0 total points
ID: 24338094
Thanks, I tried making one the users an admin and that also did not work.  I think I will spend the weekend trying to convert this software from SQL Server to MySQL.
0
 
LVL 70

Expert Comment

by:Qlemo
ID: 24338145
And Named Pipes are enabled?
0
 
LVL 1

Author Comment

by:pigparent
ID: 24338267
Yes they are, and I have confirmed that the pipe name matches the 'listening' pipe in the log file.  Thanks again for your help!
0
 
LVL 70

Expert Comment

by:Qlemo
ID: 24350178
I'll give up. If MySQL is your way, go it.
0
 
LVL 1

Author Comment

by:pigparent
ID: 24355721
Yeah, that's kinda where I am with it.  I think the server administrator disconnected it from the domain and that's what's causing the problem.  He won't put it back and nothing else I can find is working.  MySQL works every time for me, so I guess I'm left with no choice.

Thanks for trying; I really appreciate it.
0
 
LVL 1

Author Comment

by:pigparent
ID: 24410529
All, after much research i was able to fix the problem by resetting the sa password.  I had read that some strange things can happen, and that resetting the sa password might help.  I tried it, and all my problems vanished.  Go figure.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
the way to learn Microsoft BI 13 70
Set arraylist as datatable 2 29
SQL Server 2005 running VERY slowly on new hardware 22 61
VB .net 2010 Byte array 2 21
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question