Can’t get Perfmon to save data to Database

There is a common problem when Logging Perfmon counter to a SQL Table - Security.

The user used to log Perfmon counters into database must be a member of the perfmon group and it must have access to SQL Server (memeber of sysadmin role).

Error message will be something like:

The service was unable to open the log file SQL:SERVERNAME!SQL Server for log SQL Monitor and will be stopped. Check the log folder for existence, spelling, permissions, and ensure that no other logs or applications are writing to this log file. You can reenter the log file name using the configuration program. This log will not be started. The error returned is: The returned data is valid.

When creating ODBC connection, do not use SQL Native Driver as it will not work - use SQL Server driver instead.