PDA

View Full Version : Can't get Perfmon to save data to Database


Barkingdog
July 12th 07, 07:12 PM
Under Perfrmon, Performance Logs and Alerts, "Counter Logs" I added a single
counter. Under the Log Files tab I select log file type of "SQL Database"
(which is pointed to a System DSN I setup.), set the "Run As" option to my
domain name and enterted my password, hit Apply and all is well. But when I
attempt to start monitoring I get the error "The log or alert has not
started."

"Event Type: Error
Event Source: PDH
Event Category: None
Event ID: 3041
Date: 7/12/2007
Time: 11:04:43 AM
User: N/A
Computer: ISWES
Description:
The description for Event ID ( 3041 ) in Source ( PDH ) cannot be found. The
local computer may not have the necessary registry information or message DLL
files to display messages from a remote computer. You may be able to use the
/AUXSOURCE= flag to retrieve this description; see Help and Support for
details. The following information is part of the event: [Microsoft][ODBC SQL
Server Driver][SQL Server]Login failed for user ''. The user is not
associated with a trusted SQL Server connection..
Data:
0000: 14 .
"

Login failed for user " ---- well, my DSN tested out OK so I dfon't know
what is wrong. Incidnetally, the sql 2005 database I'm triyng to save
Perfmon data to is located on the same box I'm running Perfmon on.


TIA,

barkingdog

Google