We have a linked server via ODBC driver. The MSDASQL provider configuration is the following:

We have Allow inprocess unchecked as with this option checked the server crashes.

The linked server authentication mode is Be made using this security context. Server options are left default.

When the MS SQL Server is started by NT AUTHORITY\SYSTEM account the following OPENQUERY executed in Studio:

SELECT*FROMOPENQUERY(SERVICENOW,'select number, short_description from incident')

Returns the following error:

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "MSDASQL" for linked server "SERVICENOW" 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 "MSDASQL" for linked server "SERVICENOW".

If the Studio was Run as Administrator the data return correctly.

If the MS SQL Server is started by a lower privilege user, for example NT AUTHORITY\LOCAL SERVICE, regardless Run as Administrator or not the same query produces the following error:

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "MSDASQL" for linked server "SERVICENOW" reported an error. Access denied.

Msg 7350, Level 16, State 2, Line 1

Cannot get the column information from OLE DB provider "MSDASQL" for linked server "SERVICENOW".

Running the Process Monitor doesnt show any access denied operations (please see the file attached).

Weve researched this problem online and tried different solutions, for example to grant access to system32 and windows temp folders, but none of them worked.

The only thing seems to work for a lower privilege user is this http://blogs.msdn.com/b/dataaccesstechnologies/archive/2010/08/19/permissions-needed-to-set-up-linked-server-with-out-of-process-provider.aspx

• What privileges and what does the non-admin user have to have to use the linked server?
• Is this article the only way to let the regular user to use the linked server via ODBC driver? If not please provide another options. If yes please explain why.
• What is the outcome running the MS SQL Server as NT AUTHORITY\SYSTEM for pulling the data via linked server?

Thank you,

Sravan