Error 7207

Severity

17

Message text

Can't open a connection to site '%S_SRVID' because there are no remote connections available. Rerun when there are fewer remote users and/or fewer local users making remote accesses, or contact a user with System Administrator (SA) role.

Explanation

This error occurs when Adaptive Server is unable to open a connection to a remote Adaptive Server, Backup Server, or Open Server application because no remote connections are available.

There may be too many local users with active remote connections. Your System Administrator may also need to configure the server to allow more remote connections.

Action

1. Use the following query to check the remote connections currently in use:

   1> use master
   2> go
   
   1> select count(*) from sysprocesses a, sysservers b
   2> where a.hostname=b.srvname
   

2. Perform one of the following actions to resolve the problem:

   • Wait until some of the presently active connections shut down, then retry your query.

   • Configure Adaptive Server to allow more remote connections. The relevant configuration parameters are:

     • number of remote connections

     • number of remote logins

   These are static parameters. You must restart Adaptive Server after changing the values.

Refer to the System Administration Guide: Volume 1 for more information.

Additional information

Note that each simultaneous connection to and XP Server for extended stored procedure execution uses up to one remote connection.

Versions in which this error is raised

All versions