Help get this topic noticed by sharing it on Twitter, Facebook, or email.

SF_Replicate failed .. Access is denied.

Hello,
I am testing and just ran

Exec SF_Replicate 'SALESFORCE', 'Account'

for the first time,,

i get the following error

--- Starting SF_Replicate for Account V3.6.8
10:59:52: Parameters: SALESFORCE Account Version: V3.6.8
10:59:52: Drop Account_Previous20181106T105952900 if it exists.
10:59:52: Create Account_Previous20181106T105952900 with new structure.
Access is denied.
10:59:53: Error: Replicate program was unsuccessful.
10:59:53: Error: Command string is C:\"Program Files"\DBAmp\DBAmpNet2.exe Exportsoap "Replicate" "Account_Previous20181106T105952900" "SRVWSQLP14" "Salesforce_dbamp" "SALESFORCE"
--- Ending SF_Replicate. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_Replicate, Line 383 [Batch Start Line 3]
--- Ending SF_Replicate. Operation FAILED.

I have enabled Exec master..xp_cmdshell and my SQL Server service account has access to C:\"Program Files"\DBAmp\DBAmpNet2.exe

I would really appreciate if anyone can help ?

thanks
Paul
1 person has
this problem
+1
Reply