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

Error: Failed to execute command to retrieve session id.

We are getting the following error when running SF_BulkOps:

W (1): --- Starting SF_BulkOps for Account_Explorer_UPDATE
W (2): 11:47:41: Run the DBAmp.exe program.
W (3): 11:47:41: DBAmp Bulk Operations. V2.18.2 (c) Copyright 2006-2014 forceAmp.com LLC
W (4): 11:47:41: Inserting Account_Explorer_UPDATE (OOCSVODDB001V\DBAMPDEV / salesforce_backups).
W (5): 11:47:41: DBAmp is using the SQL Native Client.
W (6): 11:47:41: Error: Failed to execute command to retrieve session id.
W (7): Source: Microsoft SQL Server Native Client 11.0
W (8): Description: Cannot initialize the data source object of OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE_EXP".
W (9): Source: Microsoft SQL Server Native Client 11.0
W (10): Description: OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE_EXP" returned message "Error 5103 : FAHttp::Send::WinHttpSendRequest Invalid username or password for the proxy.".
W (11): 11:47:41: Error: Unable to populate salesforce session id.
W (12): 11:47:41: Error: DBAmp.exe was unsuccessful.
W (13): 11:47:41: Error: Command string is E:\"Program Files"\DBAmp\DBAmp.exe insert Account_Explorer_UPDATE "OOCSVODDB001V\DBAMPDEV" "salesforce_backups" "SALESFORCE_EXP" " "
W (14): --- Ending SF_BulkOps. Operation FAILED.

This is only occuring when a non-SysAdmin is executing the Stored-Procedure.

We can still run with SELECT * FROM ...

Setup is 2008 R2
Proxy Settings in DBAmp Configuration
Standard SQL Account
Created Credentials for Local Account with xp_CmdShell permissons
(Verified with DBAmp runs, using that account)

The error is indicating Invalid Username/Password, but have validated correct user name and password, we also logged in as user and made sure Internet Options referenced the same Proxy Server.

What is the next suggestion? How can we verify what user it is trying to use?
1 person has
this problem
+1
Reply
  • So your network proxy is not allowing that user access to go through the proxy.

    I would suggest connecting to your network group and ask them to check the proxy logs for the failure. That will help them construct the proper proxy rule to allow passage.

    Note: Most customers do NOT use user name/password for proxy connections that need to be made from a server/service. Instead, the network group usually constructs what is called a "direct" rule in the proxy that allows all outbound https traffic to the salesforce.com urls to pass. That removes the sensitivity of the proxy to a set of user/password credentials.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited