Cross post from Windows Server 2008 Forums
(MSFT Suggestion).ÃÂ Original Post:
I am trying to set up Perfmon to log directly to a SQLÃÂ 2008 Server
(trying to avoid binary file + relog).ÃÂ The SQL server is running
locally on the same server I am trying to record perf counters from.ÃÂ
Note that I am NOT using SQL 2008's data collection features, and I am
trying to log non-sql related counters.
I set up a SQL 2008
Native Client System DSN with Windows Authentication, but when I try
and start my data collecter set I get an error messageÃÂ that "Call to
SQLExecDirect failed with %1", and the in event viewer I get "Call to
SQLExecDirect failed with .".ÃÂ The set is running as System, which has
rights to the database.ÃÂ SQL does not log any errors or a failed logon
The ODBC DNS 'Test' button says it connected successfully, and I am
able to connect to the same database via Management Studio and ASP.Net.ÃÂ I don't think its a SQL problem, but its hard to say when the error message is blank.
Any help fixing this, or ruling out SQL as the problem, would be appreciated.
View Complete Post