Replication in Non-Trusted Domains

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’

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26


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'