Simon's SQL

SQL,DBA,tuning,Trouble Shooting,Performance

Posts Tagged ‘Non-Domain’

Replication in Non-Trusted Domains

Posted by Simon Cho on 08/14/2012

http://support.microsoft.com/kb/321822

exec sp_addpublication_snapshot
, @publisher_security_mode = 0
, @publisher_login = N’sql_Replication_user’
, @publisher_password = N’sql_Replication_user_password’


exec ReplicationDB.sys.sp_addlogreader_agent 
@job_login = null
, @job_password = null
, @publisher_security_mode = 0
, @publisher_login = N'sql_Replication_user'
, @publisher_password = N'sql_Replication_user_password'
GO

exec sp_addpublication_snapshot @publication = N'TestPublication'
, @frequency_type = 1
, @frequency_interval = 0
, @frequency_relative_interval = 0
, @frequency_recurrence_factor = 0
, @frequency_subday = 0
, @frequency_subday_interval = 0
, @active_start_time_of_day = 0
, @active_end_time_of_day = 235959
, @active_start_date = 0
, @active_end_date = 0
, @job_login = null
, @job_password = null
, @publisher_security_mode = 0
, @publisher_login = N'sql_Replication_user'
, @publisher_password = N'sql_Replication_user_password'

Posted in Common | Tagged: , | Leave a Comment »