asked on

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

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

mohan_sekar

Try this - if you are accessing the server by it's name, try by it's IP address.

pigparent

ASKER

Good suggestion though my connection string refers to it by IP address. I wouldn't know a named pipe from a sewer pipe, frankly.

SOLUTION

mohan_sekar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Qlemo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pigparent

ASKER

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!

Qlemo

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.

ASKER CERTIFIED SOLUTION

pigparent

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Qlemo

And Named Pipes are enabled?

pigparent

ASKER

Yes they are, and I have confirmed that the pipe name matches the 'listening' pipe in the log file. Thanks again for your help!

Qlemo

I'll give up. If MySQL is your way, go it.

pigparent

ASKER

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.

pigparent

ASKER

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.