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

Help with error The OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" reported an error. Access denied.

Getting the following error on a new sql instance when doing a simple select, this works fine on another sql server I have set up. The connection test works fine, settings in DBAMP config match the system that works. Any thoughts?

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" reported an error. Access denied.
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE".

The only obvious difference is that SQL Server services under individual domain accounts, a special user is created each machine that runs the services.

This is a simple test query that gets the error.

SELECT * from OpenQuery(SALESFORCE,'SELECT * FROM ca_agile__Epic__c')
Thanks
Bob
2 people have
this question
+1
Reply
  • More than likely,you skipped the step where you set the DBAmp.DBAmp provider options.

    From the DBAmp doc:

    Expand the Providers tree entry in the Object Explorer (Server Objects/Linked Servers/Providers). Right click the DBAmp.DBAmp provider entry and choose Properties.

    Check the following (leaving all other options unchecked):
    Dynamic Parameters
    Allow InProcess
    Non transacted Updates

    Please review Chapter 1 of the DBAmp manual for other needed steps in a new installation. Another common mistake is to fail to set Collation Compatible to TRUE for the linked server.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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