Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sp_changereplicationserverpasswords (Transact-SQL)
Collapse the table of content
Expand the table of content

sp_changereplicationserverpasswords (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Changes stored passwords for the Microsoft Windows account or Microsoft SQL Server 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 SQL Server 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.

Topic link icon 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 = SQL Server Authentication

[ @login = ] 'login'

Is the name of the Windows account or SQL Server 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 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.

Community Additions

ADD
Show:
© 2015 Microsoft