Do you have any workstations configured with named pipe in client network utility to access SQL Serevr without going through your application servers?

You can change the network access order by clicking the up and down arrow in client network library. Please make sure TCP/IP is set before the named pipe.

Use following statement to find out who are using named pipe.

select hostname, nt_domain, nt_username, net_library, loginame

from sysprocesses

where net_library <> ' '

order by net_library

Edited by - Allen_Cui on 05/12/2003 1:09:48 PM