I'm trying to use an established Data Collector Set to start loggging perfmon counters to a local SQL Database (on a local SQL instance). However, here's what my current setup looks like:
And when I try to run the Data Collector Set I get the following error:
Call to SQLAllocConnect failed with %1.
So I think my Data source name might be formatted incorrectly, but I can't find anything good in TechNet to walk me through that. I've created the db "PerfMon" in the SQL instance and made sure that the user running the logging has DBO rights to that database (and is also sysadmin). There's only one SQL instance on this box so I shouldn't have to specify that.
What am I missing?