AnsweredAssumed Answered

Linked Server Connection Failing

Question asked by Derek_Aherne on May 21, 2019
Latest reply on May 21, 2019 by Derek_Aherne



I have a Linked Server built in SQL Server, which I am using to run queries on piarchive, however the connection fails intermittently with the error:


"OLE DB provider "PIOLEDB" for linked server "WIND-PI" returned message "[PI SDK] Unable to access SCM Manager.  5".


Basically sometimes i get this error and other times it runs fine - we have encountered some memory problem with the host machine and have limited SQL Server to 5GB to mitigate this but nothing has changed.


It sounds like a permissions problem but the fact that the connection works fine sometimes it has me stumped. If anyone can enlighten me or suggest a fix that would be great :-)