![]() Permissions needed to set up linked server with out-of-process To be able to execute linked server queries, also set RPC OUT to true see this MSDN Blog post for reference: What is the RPC and RPC Out option on a SQL Server linked-server? but this may also be the root cause for Msg 73 if the underlying error is 0x80070005.Ġx80070005 - Essentially implies Access denied.Īnother preparational step. There is clearly a permission problem case when you get: Msg 7399. Server queries successfully locally and remotely. There are certain permissions that have to be set on MSDAINITIALIZE toīe able to initialize the provider out-of-process and run linked ![]() This MSDN post showed me the way to solve the issue: Permissions needed to set up linked server with out-of-process provider What I did: Edit DCOM MSDAINITIALIZE security settings and permissions I had to fiddle with the Registry and the DCOM configuration. I have also tried an older version of SSMS (2012) and the beta version of SQL Operations Studio (basically VS Code like SSMS, actually a 64-bit application) to no avail.Īs guessed by Mark this was a permission problem, however a not so obvious one. The driver, studio, and SQL Server must be of the same bitness.Ĭan anyone suggest a way to use a Salesforce source as a linked server along with SQL Server 2016 in an SSMS-like way? I am open to alternative solutions and 3rd-party tools. The Devart driver requires (as mentioned in the installation guide, see page 41) the same bitness of all moving parts. I found out I can indeed connect to the Salesforce ODBC source and access the data using a 3rd Party Database Manager (Database5Pro 64bit, an SSMS alternative) - but this does not allow me to access both data sources at the same time (no linked objects available). SQL Server create procedure sp_tables_info_rowset_64 [does not fix.Restart (the database engine and even Windows).MSDASQL provider: disable Allow inprocess.I have tried a few solutions that are associated with error 7302/3 but nothing seems to work: Cannot create an instance of OLE DB provider "MSDASQL" for linked server "SF". ![]() When I try to expand the Server Object tree view I get the following error: Select all Error: "Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider "MSDASQL" for linked server Whilst I can connect to the 64-bit source I cannot access the linked server object in SQL Server Management Studio 17.x (32 bit - I believe there is no 64-bit version of SSMS): "SF" returned message " The specifiedĭSN contains an architecture mismatch between the Driver andĪpplication". OLE DB provider "MSDASQL" for linked server The linked server has been created but failed a connection test.Ĭannot initialize the data source object of OLE DB provider "MSDASQL"įor linked server "SF". When I use the 32-bit ODBC source no connection can be established and the following error is shown: Testing the connection to the ODBC source only works in SSMS when I use the 64-bit source. I have created a linked server in SSMS as described in the documentation. ![]() I have problems to access a linked server for a Salesforce ODBC data source with our MS SQL Server 2016 (Standard 64-Bit) using the Devart ODBC Driver for Salesforce in SSMS and SQL Studio Management Studio (17.8.1). ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |