Article ID: 2450479 - View products that this article applies to.
Consider the following scenario:
Note: In this context a non-privileged user is a standard user who does not belong to a privileged access group at Windows level (for example: Administrators)
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider <OLEDB provider name> for linked server <Linked server name> reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider <OLEDB provider name> for linked server.
When an OLE DB provider is run out of process, the OLE DB Interface Remoting Dll (msdaps.dll) handles the communication between the proxy side process, in which OLE DB consumer resides, and the stub side process, in which OLE DB provider resides. In the current implementation. OLE DB Remoting uses named file mapping objects to transmit OLE DB rowset data. On systems running Vista or a later version of the operating system, the proxy side and the stub side are run in different sessions because of Session 0 isolation
(http://www.microsoft.com/whdc/system/sysinternals/Session0Changes.mspx)and hence OLE DB Remoting must use a global for proxy-stub communication on these systems. However, since the user account does not have sufficient privileges to create a global file mapping object in the specified linked server configuration, the proxy-stub communication cannot be initiated resulting in error messages discussed in the Symptoms section of this article.
You can workaround the problem using either of the following methods:
Workaround 1: Configure the OLEDB provider to run in-process.
Note: You cannot use this workaround for OLEDB providers that are based on .Net versions that are earlier than 4.0.
Workaround 2:Assign the users the "Create global objects" user right. To do this, follow these steps:
Status: Microsoft is currently working on fixing this issue in a future release of the product.
(http://go.microsoft.com/fwlink/?LinkId=151500)for other considerations.
Article ID: 2450479 - Last Review: March 9, 2011 - Revision: 3.0