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