PRB: Remote Stored Procedure Call Fails with Error 7221

ID: Q129604

The information in this article applies to:

SYMPTOMS

Under certain circumstances when you run a remote stored procedure, you could receive the following error on the SQL Server where the remote stored procedure is initiated:

Msg 7221, Level 17, State 2
Login to site '<server name>' failed


CAUSE

The conditions for this error to occur are:

  1. The SQL Server where the Remote Stored Procedure is initiated is running with the local system account.


  2. The Open Data Services (ODS) application that services the remote stored procedure is run on Windows NT version 3.5 or later.


This error occurs because SQL Server is not able to connect to the named pipe that the ODS application is listening on because, by default, the local system account has no permissions to connect to a named pipe on Windows NT version 3.5 or later on another computer.


WORKAROUND

In order to enable SQL Server to connect with the local system account, you should ensure that the named pipe that the remote ODS application is listening on is included in the NullSessionPipes value of the HKEY_LOCAL_MACHINE setting SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters for the server that is running the ODS application. You should then reboot that server.

For example, if you are running the sample ODS application PROCSRV on a server named NTSRV and listening on the named pipe \\.\pipe\procsrv\query, you would need to add procsrv\query to the NullSessionPipes value on the server NTSRV.

Additional query words: RPC 


Keywords          : kbtool SSrvLAN SSrvNet_Lib 
Version           : 4.2 4.21 4.21a
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 20, 1999