PRB: Remote Stored Procedure Call Fails with Error 7221Last reviewed: April 30, 1997Article ID: Q129604 |
The information in this article applies to:
SYMPTOMSUnder 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 CAUSEThe conditions for this error to occur are:
WORKAROUNDIn 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
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |