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

creating linked server error salerforce to sql server.

Hi
I just used your DBAmp/Pro for connecting salesforce database to sqlserver .. i followed Manual . now when i create linked server i get following error.TITLE: Microsoft SQL Server Management Studio
------------------------------

"The linked server has been created but failed a connection test. Do you want to keep the linked server?"

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Cannot initialize the data source object of OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE".
OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" returned message "Error 5103 : FAHttp::Send::WinHttpSendRequest
Win32Error::
A connection with the server could not be established
". (Microsoft SQL Server, Error: 7303)

and i have a confusion about security option in linked server ..
I'm using SQL 2005 ..
Kindly help me to access salesforce database ..
Thanks and regrads

For help, click: http://go.microsoft.com/fwlink?ProdNa...

------------------------------
BUTTONS:

&Yes
&No
------------------------------
1 person has
this question
+1
Reply
  • "A connection with the server could not be established."

    DBAmp is unable to access the salesforce.com server because there is not a valid internet connection.

    Normally, this error occurs because a proxy is required in your environment to get to the internet. Run the DBAmp Configuration Program, menu choice Options and configure the proxy.

    Then try the Test Connection option of the DBAmp Configuration to make sure the proxy works. Once you get a successful connection there, set up the linked server again.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • many thanks for the reply ..
    Actually i followed all the steps that is mentioned in PDF for DBAmp Configuration Program but now I faced issue to understand Proxy .
    Like ;
    There is option
    Proxy UserName;
    Proxy Password:
    Proxy URL:
    Proxy ConfigURL :

    What Information should I enter in this ..?

    Is this a saleforce ID and Password and what is it ?

    Kindly help me ..
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • I’m thankful
    hi

    actually there is an internet security issue actually we can not access internet on this server so talking to IT guys i just start internet on this server where SQL installed ..

    I followed these steps;
    Linked Server: Enter SALESFORCE
    Provider: Choose DBAmp OLE DB Provider
    Product Name: Enter DBAmp
    Location: Blank
    For Remote Login:, enter your salesforce.com UserId.
    For With password: enter your salesforce password.

    Now its working Fine ..

    Thanks for your Quick response..
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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