AnsweredAssumed Answered

PI Collective with SSRS report

Question asked by Kaush12 on Sep 11, 2016
Latest reply on Oct 4, 2016 by dwang

Hi ,

I have a query ,Can we connect PI Collective server with SSRS report ? If yes please provide me details step to achieve this?

 

Primary Historian Server name (HISTORIAN01) Secondary Historian Server name( HISTORIAN02) , Collective name ( Same as Primary Historian server name)

 

Right now I am using linked server to configure with PI OLEDB provider  (KB01143 - How to configure a linked server with PI OLEDB or PI OLEDB Enterprise ) this article

 

But it connect only with primary Historian server .after Stopping services of  primary historian server , secondary historian server could not able to connect with linked server as datasouce name is primary server.  i am attaching screenshot configuration of Linked server and Error mesage

 

 

error messaage after stopping primary Historian Server

 

Please help me solve out these issue.

 

Thanks in advance

Outcomes