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 :-)