Error 7221

Severity

14

Message text

Login to site '%S_SRVID' failed.

Explanation

This error occurs when you execute a remote procedure call (RPC) in one of the following situations:

• A name was not assigned, via sp_addserver, to the Adaptive Server which is initiating the RPC.

• A remote login for the Adaptive Server initiating the RPC was not added to the Adaptive Server that is receiving the RPC.

• The Adaptive Server receiving the RPC is not configured for allow remote access or for high enough values for number of remote sites or number of remote connections.

• The Adaptive Server receiving the RPC does not have an entry in the network addressing (interfaces or sql.ini) file for the Server initiating the RPC (or the other way around).

• The Adaptive Server receiving the RPC is in single-user mode and already had one user at the time the RPC was executed.

• The password for the user initiating the RPC is not the same on both Adaptive Servers.

Action

Eliminate the 7221 error by determining which of the above situations applies to you and following the appropriate steps:

1. A name was not assigned to the Adaptive Server that is initiating the RPC.

   Use the select @@servername command to check if the Adaptive Server initiating the RPC has a name assigned to it.

   If the select @@servername command returns the name of the server which is initiating the RPC, then continue to step 2.

   If the output returned by select @@servername is NULL, then assign a name to the local Adaptive Server using the sp_addserver command:

   1> sp_addserver <name_of_server_initiating_rpc>,local
   2> go
   

   Refer to “sp_addserver” in the Reference Manual: Procedures for information about valid Adaptive Server names.

   Restart Adaptive Server after assigning it a name. Usually you want to name an Adaptive Server the same name as is stored in the DSQUERY environment variable or the name which is used in the -S option when the server is accessed via isql. For example:

   % isql -SPRODUCTION
   

   In the above example, “PRODUCTION” is the Adaptive Server name.

2. A remote login was not added to the Adaptive Server that is receiving the RPC for the Adaptive Server that is initiating it.

   Use sp_helpremotelogin to check if the receiving Adaptive Server has a remote login for the Adaptive Server initiating the RPC. If the output returned by sp_helpremotelogin contains information about the remote Adaptive Server, then continue to step 3.

   If the output returned by sp_helpremotelogin does not contain information about the remote Adaptive Server, then add a remote login to the remote Adaptive Server for the Adaptive Server that is initiating the RPC by typing the following (on the remote Adaptive Server):

   1> sp_addremotelogin <name_of_server_initiating_rpc> 
   2> go
   

3. The Adaptive Server receiving the RPC is not configured for allow remote access or for high enough values for number of remote sites or number of remote connections.

   Check the remote Adaptive Server’s error log for more information on why the RPC initiated by the local Adaptive Server did not succeed. Refer to “Setting Configuration Parameters” in the System Administration Guide: Volume 1 for information about how to turn on allow remote access and how use sp_configure to raise the values of number of remote sites or number of remote connections.

4. The Adaptive Server receiving the RPC does not have an entry in the interfaces file for the Server initiating the RPC (or the other way around).

   Add the required entries for the Adaptive Server initiating the RPC to the interfaces file of the receiving Server. Use one of the following utilities or copy the entries from the interfaces file of the initiating Server and make sure that they have a tab in front of each entry.:

   • dsedit

   • dscp

5. The Adaptive Server receiving the RPC is in single-user mode and already has one user at the time the RPC is executed.

   Wait until the receiving Adaptive Server is not being used, then execute the RPC or restart the receiving Adaptive Server in multiuser mode.

6. The password for the user initiating the RPC is not the same on both Servers.

   Make user passwords the same for the remote Adaptive Server.

Additional information

For more information, refer to: