sp_autoconnect

(Component Integration Services only) Defines a passthrough connection to a remote server for a specific user, which allows the named user to enter passthrough mode automatically at login.

Syntax

sp_autoconnect server, {true | false} [, loginame]

Parameters

server – is the name of a server to which an automatic passthrough connection is made. server must be the name of a remote server already added by sp_addserver. This server cannot be the local server.
true | false – determines whether the automatic passthrough connection is enabled or disabled for server. true enables the automatic connection. false disables it.
loginame – specifies the name of the user for which automatic connection is required. If no loginame is supplied, the autoconnect status is modified for the current user.

Examples

Example 1 – The current user is automatically connected to the server MYSERVER the next time that user logs in. The user’s connection is placed in passthrough mode:
```
sp_autoconnect MYSERVER, true
```
Example 2 – Disables the autoconnect feature for the user “steve”:
```
sp_autoconnect MYSERVER, false, steve
```

Usage

sp_autoconnect defines a passthrough connection to a remote server for a specific user, which allows the named user to enter passthrough mode automatically at login.
Use sp_autoconnect only when Component Integration Services is installed and configured.
Do not change the autoconnect status of the “sa” login account.
Changing the autoconnect status does not occur immediately for users who are currently connected. They must disconnect from the local server, then reconnect before the change is made.
Use disconnect to exit passthrough mode.

See also connect to...disconnect, grant in Reference Manual: Commands.

Permissions

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

Setting	Description
Enabled	With granular permissions enabled, you must be a user with `manage any login`privilege. Any user can execute sp_autoconnect for themselves.
Disabled	With granular permissions disabled, you must be a user with sa_role. Any user can execute sp_autoconnect for themselves.

Auditing

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

Information	Values
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