Bannikov

PI OLEDB Enterprise Error -- Access Denied

Discussion created by Bannikov on Feb 9, 2012
Latest reply on Mar 5, 2012 by aabrodskiy

Hello!

 

I've encontered the problem like described in this thread -- http://vcampus.osisoft.com/discussion_hall/development_with_other_osisoft_products/f/9/p/392/1655.aspx -- but with PI OLEDB Enterprise.

 

I've added AF Server as linked server to MS SQL Server 2008 R2 Standard Edition, and I've the same error for any queries againts AF Server (just for example, this query is very simpe:

 

select * from OpenQuery ([NN-AF01], 'SELECT top 1 * FROM [ЦСТИ].[Asset].[ElementHierarchy] eh');

 

 

 

The message I've got is following:

 

Msg 7399, Level 16, State 1, Line 1

 

The OLE DB provider "PIOLEDBENT" for linked server "NN-AF01" reported an error. Access denied.

 

Msg 7350, Level 16, State 2, Line 1

 

Cannot get the column information from OLE DB provider "PIOLEDBENT" for linked server "NN-AF01".

 

Maybe someone here help me with this issue, or I should revert to standard tech support? Thank you!

 

 

Outcomes