sp_addserver

Defines a remote server, or the name of the local server; specifies the server for remote procedure calls (RPCs) when using the host and port parameters.

Syntax

sp_addserver lname [, class [, pname]]

Component Integration Services (CIS) only:

sp_addserver 'logical_server_name', ASEnterprise, 'host:port:filter'

Parameters

Examples

Usage

There are additional considerations when using sp_addserver:
  • The sysservers table identifies the name of the local server and its options, and any remote servers that the local server can communicate with.

    To execute a remote procedure call on a remote server, the remote server must exist in the sysservers table.

  • If lname already exists as a server name in the sysservers table, sp_addserver changes the remote server’s srvnetname to the name specified by pname. When it does this, sp_addserver reports which server it changed, what the old network name was, and what the new network name is.

  • The installation or upgrade process for your server adds an entry in sysservers for a Backup Server. If you remove this entry, you cannot back up your databases.

  • The SAP ASE server requires that the Backup Server have an lname of SYB_BACKUP. If you do not want to use that as the name of your Backup Server, or if you have more than one Backup Server running on your system, modify the pname for server SYB_BACKUP with sp_addserver so that the SAP ASE server can communicate with Backup Server for database dumps and loads.

  • If you specify an lname, pname and class that already exist in sysservers, sp_addserver prints an error message and does not update sysservers.

  • Use sp_serveroption to set or clear server options.

See also Remote Servers in Component Integration Services User’s Guide.

Permissions

The permission checks for sp_addserver differ based on your granular permissions settings.

SettingDescription
Enabled

With granular permissions enabled, you must be a user with manage server privilege.

To execute sp_addserver for a server that is a shared disk cluster, you must be a user with manage cluster privilege and manage server privilege.

Disabled

With granular permissions disabled, you must be a user with sso_role.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

InformationValues
Event

38

Audit option

exec_procedure

Command or access audited

Execution of a procedure

Information in extrainfo
  • Roles – Current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – All input parameters

  • Proxy information – Original login name, if set proxy in effect

Related reference
sp_addremotelogin
sp_dropremotelogin
sp_dropserver
sp_helpremotelogin
sp_helpserver
sp_serveroption