asked on

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.

Daniel Wilson

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!

ifcosystems

ASKER

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?

Daniel Wilson

doubtful.

It looks like a permissions issue.

ifcosystems

ASKER

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.

Daniel Wilson

Maybe ... won't hurt to give it a try!

ASKER CERTIFIED SOLUTION

ifcosystems

membership

This solution is only available to members.

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

Start Free Trial