sp_adddistpublisher

Transact-SQL Reference

Transact-SQL Reference

sp_adddistpublisher

Configures a Publisher to use a specified distribution database. This stored procedure is executed at the Distributor on any database. Note that the stored procedures sp_adddistributor and sp_adddistributiondb must have been run prior to using this stored procedure.

Syntax

sp_adddistpublisher [ @publisher = ] 'publisher'
    
[ , @distribution_db = ] 'distribution_db'
    
[ , [ @security_mode = ] security_mode ]
    [ , [ @login = ] 'login' ]
    [ , [ @password = ] 'password' ]
    
{ , [ @working_directory = ] 'working_directory' }
    [ , [ @trusted = ] 'trusted' ]
    [ , [ @encrypted_password = ] encrypted_password ]
    [ , [ @thirdparty_flag = ] thirdparty_flag ]

Arguments

[@publisher = ] 'publisher'

Is the Publisher name. publisher is sysname, with no default.

[@distribution_db = ] 'distribution_db'

Is the name of the distribution database. distributor_db is sysname, with no default. This parameter is used by replication agents to connect to the Publisher.

[@security_mode = ] security_mode

Is the implemented security mode. This parameter is used by replication agents to connect to the Publisher. security_mode is int, and can be one of these values.

Value Description
0 Replication agents at the Distributor use SQL Server Authentication to connect to the Publisher.
1 Replication agents at the Distributor use Windows Authentication to connect to the Publisher.
NULL (default) System will change the value to 0 if the server (Distributor) is running on the Windows® 95 or Windows 98 operating system. System will change the value to 1 if the server (Distributor) is on a Windows NT® 4.0 or Windows 2000 operating system.

[@login = ] 'login'

Is the login. This parameter is required if security_mode is 0. login is sysname, with a default of sa. This parameter is used by replication agents to connect to the Publisher.

[@password = ] 'password']

Is the password. password is sysname, with a default of NULL. This parameter is used by replication agents to connect to the Publisher.

[@working_directory = ] 'working_directory'

Is the name of the working directory used to store data and schema files for the publication. working_directory is nvarchar(255). The name should be specified in UNC format.

[@trusted = ] 'trusted'

Is when the remote Publisher uses the same password as the local Distributor. trusted is nvarchar(5), and can be one of these values.

Value Description
True One trusted login mapping is added: sa to distributor_admin. Because the mapping is trusted, no password is needed at the remote Publisher to connect to the Distributor.
False One nontrusted mapping is added: distributor_admin to distributor_admin. A password is needed at the remote Publisher to make a connection.
NULL (default) If the distribution Publisher is local, the system will change the value to false (nontrusted). Any password set for the Distributor is also set for the local distribution Publisher (linked server connection back to local Distributor). If the distribution Publisher is remote, the system will change the value to true (trusted) and no password is needed at the remote Publisher. If the user changes the distributor_admin password directly, instead of using sp_changedistributor_password, the local link is broken.

[@encrypted_password = ] encrypted_password

Is when the password is encrypted. encrypted_password is bit, with a default of 0. If 1, password is stored in encrypted form.

[@thirdparty_flag = ] thirdparty_flag

Is when the Publisher is Microsoft® SQL Server™. thirdparty_flag is bit, and can be one of these values.

Value Description
0 (default) Microsoft SQL Server database.
1 Database other than SQL Server.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_adddistpublisher is used by snapshot replication, transactional replication, and merge replication.

Permissions

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

See Also

sp_changedistpublisher

sp_dropdistpublisher

sp_helpdistpublisher

System Stored Procedures