June 20, 2016 at 8:54 am
I set up my Distribution on one server and the publication on a second one. The snapshot folder is a network path to a folder on the publication server. Once the publication is finished.. the job fails.. with the following error. Anyone know where I should start looking for a problem?
2016-06-20 09:25:28 - ! [LOG] Step 2 of job 'R2D2-Data_Mart-DataMartSnap-1' (0x2FA7DE39B2D92348952B662DFBCDA712) cannot be run because the Snapshot subsystem failed to load. The job has been suspended
June 20, 2016 at 11:55 am
I can run just fine, using the same AD account I used for the publication, if I use windows cmd.
C:\Program Files\Microsoft SQL Server\100\COM>snapshot.exe -Publisher [R2D2] -PublisherDB [Data_Mart] -Distributor [R2D2] -Publication [DataMart
Snap] -DistributorSecurityMode 1
2016-06-20 17:34:02.16 Time spent posting snapshot commands (seconds): 0.17
2016-06-20 17:34:02.16
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply