(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.
sp_autoconnect server, {true | false} [, loginame]
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.
determines whether the automatic passthrough connection is enabled or disabled for server. true enables the automatic connection. false disables it.
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.
The current user is automatically connected to the server SYBASE the next time that user logs in. The user’s connection is placed in passthrough mode:
sp_autoconnect SYBASE, true
Disables the autoconnect feature for the user “steve”:
sp_autoconnect SYBASE, false, steve
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.
The permission checks for sp_autoconnect differ based on your granular permissions settings.
Granular permissions enabled |
With granular permissions enabled, you must be a user with manage any login privilege. Any user can execute sp_autoconnect for themselves. |
Granular permissions disabled |
With granular permissions disabled, you must be a user with sa_role. Any user can execute sp_autoconnect for themselves. |
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
|---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|
Commands connect to...disconnect, grant
System procedures sp_addlogin, sp_addserver, sp_passthru, sp_remotesql
