<div>
Of course, the preferred way is the opposite direction as Captain suggested but I have nothing against Linked server tests, so I've been answering the question at the first place. :-)
</div>


Of course, the preferred way is the opposite direction as Captain suggested but I have nothing against Linked server tests, so I've been answering the question at the first place. :-)

<div>
Thanks for your help.<br />
Actually I solved this issue adding the user for SQL Server service to the admin users group.
</div>


Thanks for your help.
Actually I solved this issue adding the user for SQL Server service to the admin users group.

<div>
<div class="content wysiwyg-content">
I'm trying to set up a linked server within a sql server 2008 r2 express database.<br />
The user for sql service it's not the default one, i'm using, sqlsrv (created within user domain group). <br />
The linked server is created but every query returns this error<br />
&quot;Msg 7399, Level 16, State 1, Line 1<br />
The OLE DB provider &quot;VFPOLEDB.1&quot; for linked server &quot;amee_sec&quot; reported an error. Access denied.<br />
Msg 7301, Level 16, State 2, Line 1<br />
Cannot obtain the required interface (&quot;IID_IDBCreateCommand&quot;) from OLE DB provider &quot;VFPOLEDB.1&quot; for linked server &quot;&lt;linked server name&gt;&quot;.
</div>
</div>


I'm trying to set up a linked server within a sql server 2008 r2 express database.
The user for sql service it's not the default one, i'm using, sqlsrv (created within user domain group). 
The linked server is created but every query returns this error
"Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "VFPOLEDB.1" for linked server "amee_sec" reported an error. Access denied.
Msg 7301, Level 16, State 2, Line 1
Cannot obtain the required interface ("IID_IDBCreateCommand") from OLE DB provider "VFPOLEDB.1" for linked server "<linked server name>".

SQL Server linked server error

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.