Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m going with the flow.

Unable to connect to Salesforce

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click:


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


Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE". The provider supports the interface, but returns a failure code when it is used. (Microsoft SQL Server, Error: 7311)

For help, click:

We are attempting to connect to the linked server and we are getting the above error. Up until 2 days ago, this was working fine. Now we see this issue. We have restarted the SQL Server, tried to update credentials with no luck. We are also Single Sign On enabled and have been for approx a month so we dont think this is the issue. As of now we are unable to connect, any help you may be able to provide would be greatly appreciated.
1 person has
this problem