Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m frustrated

Issues connecting to Salesforce

Hello I'm trying to connect to Salesforce from a server. Right now, the server has a scheduled run to run as system admin which DBamp is configured to use SQL authentication to login. (I saw a similar post, which suggested to switch trusted connection to yes, but shouldn't the login be through SQL?)

When initially testing on my dev environment all the config works, but moving it to production is causing issues.

This is one of them, please help!:

--- Starting SF_BulkOps for SADR__c_Delete
22:53:02: Run the DBAmp.exe program.
22:53:02: DBAmp Bulk Operations. V2.18.3 (c) Copyright 2006-2014 forceAmp.com LLC
22:53:02: Deleting Id's using SADR__c_Delete (SQL01 / SFDC) .
22:53:03: Error: Unable to open SQL Server Source with SQLNCLI.
22:53:03: Connection string is SERVER=SQL01;DATABASE=SFDC;Trusted_Connection=No;UID=sa ; PWD=password;Packet Size=4096
Source: Microsoft SQL Server Native Client 10.0
Description: Login failed for user 'sa '.
Source: Microsoft SQL Server Native Client 10.0
Description: Invalid connection string attribute
22:53:03: Error: DBAmp.exe was unsuccessful.
22:53:03: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe delete:bulkapi SADR__c_Delete "SQL01" "SFDC" "SALESFORCE" " "
--- Ending SF_BulkOps. Operation FAILED.
1 person has
this problem
+1
Reply