I set up a linked server using these instructions: https://dcx.sap.com/index.html#sqla170/en/html/3bd909916c5f1014afdcdf4c723b1ec7.html

I get the following error when opening the Table or View nodes in MSSMS:

The OLE DB provider "SAOLEDB.17" for linked server "SQL ANYWHERE 17 CUSTDB" reported an error. Access denied. Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provider "SAOLEDB.17" for linked server "SQL ANYWHERE 17 CUSTDB". (Microsoft SQL Server, Error: 7399)

asked 10 Oct, 16:11

topwiz's gravatar image

topwiz
112
accept rate: 0%

Can you verify that you completed step 5 "Allow Inprocess"? The erroris typically because that step has not been completed.

(10 Oct, 20:48) Chris Keating

Yes, I have that set. I set the usual SA userid/password under 'Be made using this security context'.

(11 Oct, 08:55) topwiz

If that is not working for you, I am at a loss as to what is causing this. From Management Studio, when you expand the Catalogs for the linked server than you have defined, is the name 'default' or the name of the database that you are connecting i.e., for the SQL Anywhere 17 Demo, the catalog name should be 'demo' (In case it is a refresh issue, select View | Refresh or F5). If the value is still default after a refresh and that is not the actual database name, it suggests that "Allow inprocess" is not enabled.

(11 Oct, 16:28) Chris Keating

Yes it is 'default'. Now I am getting a different message but same error number: The OLE DB provider "SAOLEDB.17" for linked server "SQL ANYWHERE 17 CUSTDB" reported an error. Authentication failed. Cannot initialize the data source object of OLE DB provider "SAOLEDB.17" for linked server "SQL ANYWHERE 17 CUSTDB". (Microsoft SQL Server, Error: 7399)

(12 Oct, 12:55) topwiz

I tried adding my SQL server userid/password to Custdb and gave it SYS role. Now the link from MSSMS can't even connect with my user or dba. I've given up. Thanks for trying.

(12 Oct, 13:08) topwiz
Replies hidden

What SQL Server version do you use?

(12 Oct, 14:32) Volker Barth

I learned another case in which "default" will be reported as the catalog name. It can also occur when a connection cannot be established to the linked server - and the new error you report confirms that a connection is not established. By default, MSS running as a service would not be able to connect using shared memory. Are you connecting to a running SQLA server using TCPIP?

(12 Oct, 21:55) Chris Keating
More comments hidden
showing 5 of 7 show all flat view
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×37

question asked: 10 Oct, 16:11

question was seen: 141 times

last updated: 12 Oct, 21:55