I have setup the Sql 2008 Data Collection, and there are 3 default collection sets, yet when I try to setup the data collectors on a remote server (log perf counters to sql), I get:
WHen attempting to start the Data Collector Set the
following system error occured:
Call to SQLAllocConnect failed with %1.
My goal is to collect performance statistics from all my Windows 2008 machines in the PDW of the sql 2008 server.