SQL Server [DBNMPNTW]Access denied Error

I moved a SQL Server 2000 db on Windows 2000 to a Windows 2003 server using SQL Server 2005.  I have 5 load-balanced web servers hitting this db.  Users are getting an intermittent error:

Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNMPNTW]Access denied.

I am only seeing this error a few times an hour which makes it hard to reproduce.
ifcosystemsAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ifcosystemsConnect With a Mentor Author Commented:
I solved this:  Turns out one of my servers is using MDAC 2.53.6200, who's default behavior is to use named pipes.  I changed the connection string on this server to use dbmssocn (TCP/IP), and all is well.  Give me 500 points!
0
 
Daniel WilsonCommented:
Try using SQL Profiler to trap & log Failed Login Attempts.

This should tell you:
* Who
* what program
* What computer

That should get you close to solving it ... hopefully!
0
 
ifcosystemsAuthor Commented:
I noticed the old Windows 2000/SQL Server 2000 had the protocols TCP/IP and Named Pipes enabled.  The new server only has TCP/IP enabled.  Could that have anything to do with it?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Daniel WilsonCommented:
doubtful.

It looks like a permissions issue.
0
 
ifcosystemsAuthor Commented:
Hopefully I'm on to something...If you look at http://support.microsoft.com/kb/238949, it says DBNMPNTW is for named pipes.  Since I have that disabled on the SQL Server, wouldn't that be the reason for the error?  And the reason that some users are connecting and some are not could be that most of the web servers are using dbmssocn (TCP/IP), but sometimes they are using DBNMPNTW.  Make sense?  Then the question becomes why is DBNMPNTW being used sometimes?  The 5 web servers are using asp pages that use a UDL to connect.  I don't know how the UDL determines which network library to use.
0
 
Daniel WilsonCommented:
Maybe ... won't hurt to give it a try!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.