Skip to content

Latest commit

 

History

History
83 lines (58 loc) · 3.28 KB

sp-changereplicationserverpasswords-transact-sql.md

File metadata and controls

83 lines (58 loc) · 3.28 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sp_changereplicationserverpasswords (Transact-SQL)
Changes stored passwords for the Windows account or SQL Server login used by replication agents.
VanMSFT
vanto
randolphwest
07/05/2024
sql
replication
reference
sp_changereplicationserverpasswords_TSQL
sp_changereplicationserverpasswords
sp_changereplicationserverpasswords
TSQL

sp_changereplicationserverpasswords (Transact-SQL)

[!INCLUDE SQL Server SQL MI]

Changes stored passwords for the Windows account or [!INCLUDE ssNoVersion] 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 [!INCLUDE ssNoVersion] 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.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

sp_changereplicationserverpasswords
    [ @login_type = ] login_type
    , [ @login = ] N'login'
    , [ @password = ] N'password'
    [ , [ @server = ] N'server' ]
[ ; ]

Arguments

[ @login_type = ] login_type

The type of authentication for the supplied credentials. @login_type is tinyint, with no default.

  • 1 = Windows Integrated Authentication
  • 0 = [!INCLUDE ssNoVersion] Authentication

[ @login = ] N'login'

The name of the Windows account or [!INCLUDE ssNoVersion] login being changed. @login is nvarchar(257), with no default.

[ @password = ] N'password'

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 = ] N'server'

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.

Return code values

0 (success) or 1 (failure).

Remarks

sp_changereplicationserverpasswords is used with all types of replication.

Permissions

Only members of the sysadmin fixed server role can execute sp_changereplicationserverpasswords.

Related content