17
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.
This error occurs when you execute a remote procedure call (RPC) and the sending or receiving server is not configured for remote access.
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.
Refer to “Allowing remote access” in System Administration Guide: Volume 1 and “sp_configure” in the Reference Manual: Procedures.
All versions