October 3, 2005 at 8:18 am
I am trying to output Counter Logs from Performance Monitor to SQL Server database. I created a System DSN TEMPSQL for the database that I want to receive my log and I tested it successfully from ODBC Data Source Administrator.
When I try to start the Counter log that I defined using this DSN I get this message in the Application Log:
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]Cannot open database
"Monitoring" requested by the login. The login failed..
Event Id 2004: the server was unable to open the log file SQL:TEMPSQL!TEMPSQL_000003 for TEMPSQL and will be stopped.
Any ideas?
Gabriela
October 3, 2005 at 10:52 am
Gabriella.
when you test a data source you provide the login name and password.
when you try to connect from Performance Monitor it is the person who is running the process(most probably your Windows login) who needs access to the database. What Operating System you are using? You say "Performance Monitor" is it NT4? or it is Performance tool or is it System Monitor? for Windows 200 and 2003? Is the logging try to run as a job? Did you use Run As on a General tab in Counter properties?
Yelena
Regards,Yelena Varsha
October 3, 2005 at 11:02 am
Sorry, Yelena, I mean Performance Tool, as in Windows 2003.
I tried to use both SQL account and Windows login for the ODBC DSN. Is not working etiher way. Anyways, the account I was logged with was sysadmin on that SQL Server instance. My guess too is that the problem is somewhere in access rights, but I just can't find it!
Is working on a different configuration (different server and SQL Server installation), so the problem is not the way I setup the DSN and the Counter Log.
Thanks, anyway.
I will wait for other suggestions, who knows?
Gabriela
May 5, 2006 at 11:39 am
I experiencing the exact same problem. I trying to collect info on 55 different servers from my Windows 2003 virtual server. I have full admin access on the virtual server. I used my network acct in the Run As box to ensure that network access is not the issue.
What I'm wondering - could the issue be my access on the remote servers that I am trying to run monitors on?
If you found a solution, can you let me know what it is? If not, can you tell me if you are running System Monitor on a local server or on a remote server(s)?
Thanks!
Starr
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply