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

I have my Linked Servers configured and can query them but am unable to replicate any tables.

Here is the error I'm seeing.

--- Starting SF_Replicate for Account
21:16:17: Drop Account_Previous if it exists.
21:16:17: Create Account_Previous with new structure.
21:16:17: Run the DBAmp.exe program.
21:16:17: DBAmp Bulk Operations. V2.14.7 (c) Copyright 2006-2012 forceAmp.com LLC
21:16:17: Populating local table Account_Previous , AMAZONA-9O8KMSU\MSQLP00 / Prologis_Dev .
21:16:17: Error: Unable to open SQL Server Source with SQLNCLI.
21:16:17: Connection string is SERVER=AMAZONA-9O8KMSU\MSQLP00;DATABASE=Prologis_Dev;Trusted_Connection=No;UID=Userid; PWD=Pwd;Packet Size=4096
Source: Microsoft SQL Server Native Client 10.0
Description: Login failed for user 'Userid'.
Source: Microsoft SQL Server Native Client 10.0
Description: Invalid connection string attribute
21:16:17: Error: DBAmp.exe was unsuccessful.
21:16:17: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe Export "Account_Previous" "AMAZONA-9O8KMSU\MSQLP00" "Prologis_Dev" "PROLOGIS_DEV"
--- Ending SF_Replicate. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_Replicate, Line 214
--- Ending SF_Replicate. Operation FAILED.
1 person has
this problem
+1
Reply