Error 7227

Severity

17

Message text

Can't open a connection to site '%S_SRVID' because Adaptive Server is not configured for remote access. Ask a user with System Administrator (SA) role to reconfigure Adaptive Server to allow remote access.

Explanation

This error occurs when you execute a remote procedure call (RPC) and the sending or receiving server is not configured for remote access.

Action

Configure the local or remote Adaptive Server for remote access by changing the allow remote access configuration parameter via sp_configure.

1> sp_configure "allow remote access", 1
2> go

After enabling the allow remote access configuration parameter and restarting Adaptive Server, the number of remote logins, number of remote sites, number of remote connections, and remote server pre-read packets configuration parameters are set to their default values.

If you determine that the default values for number of remote logins, number of remote sites, number of remote connections, and remote server pre-read packets are not adequate for your needs, use sp_configure to change these configuration parameters as well.

Restart Adaptive Server to make the configuration change take effect.

Additional information

Refer to “Allowing remote access” in System Administration Guide: Volume 1 and “sp_configure” in the Reference Manual: Procedures.

Versions in which this error is raised

All versions