For complicated reasons, I have some servers that cannot have an PI components on them, but I would still like to use PI and AF to track their performance. I can get the Performance Counter data into SQL, but trying to pull it into an AF table on another server is proving difficult.
I have 2 tables, one for the counter name, and one for the counter details. The names pull down just fine, but the details are not working. I have the following set up in SQL and AF.
This works OK and Text Connection is a success
This is my query in SQL
and in AF
I am getting the following error after hitting OK
Event viewer is not much help and I am at a loss. Any assistance would be gratefully received.