| title | sp_changereplicationserverpasswords (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| applies_to |
|
||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 9333da96-3a1c-4adb-9a74-5dac9ce596df | ||
| caps.latest.revision | 27 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Changes stored passwords for the [!INCLUDEmsCoName] Windows account or [!INCLUDEmsCoName] [!INCLUDEssNoVersion] login used by replication agents when connecting to servers in a replication topology. You would normally have to change a password for each individual agent running at a server, even if they all use the same login or account. This stored procedure enables you to change the password for all instances of a given [!INCLUDEssNoVersion] Login or Windows account used by all replication agents that run at a server. This stored procedure is executed at any server in the replication topology on the master database.
Transact-SQL Syntax Conventions
sp_changereplicationserverpasswords [ @login_type = ] login_type
, [ @login = ] 'login'
, [ @password = ] 'password'
[ , [ @server = ] 'server' ]
[ @login_type = ] login_type
Is the type of authentication for the supplied credentials. login_type is tinyint, with no default.
1 = Windows Integrated Authentication
0 = [!INCLUDEssNoVersion] Authentication
[ @login = ] 'login'
Is the name of the Windows account or [!INCLUDEssNoVersion] login being changed. login is nvarchar(257), with no default
[ @password = ] 'password'
Is the new password to be stored for the specified login. password is sysname, with no default.
Note
After changing a replication password, you must stop and restart each agent that uses the password before the change takes effect for that agent.
[ @server = ] 'server'
Is the server connection for which the stored password is being changed. server is sysname, and can be one of these values:
| Value | Description |
|---|---|
| distributor | All agent connections to the Distributor. |
| publisher | All agent connections to the Publisher. |
| subscriber | All agent connections to the Subscriber. |
| % (default) | All agent connections to all servers in a replication topology. |
0 (success) or 1 (failure)
sp_changereplicationserverpasswords is used with all types of replication.
Only members of the sysadmin fixed server role can execute sp_changereplicationserverpasswords.