Solved

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

Posted on 2009-05-07
12
307 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
What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

 
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

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

726 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