Re: PerfMon recording to SQL 2005

I found that it's good to create a nonclustered index on
CounterData.CounterDateTime in advance, and rename the CounterData table at a
regular interval before it gets too large.

Linchi

"Tony" wrote:

Hi John,

Sorry for the delay but I figured it out. I had to setup the DSN with a
user on SQL and set the Run As with a user on the domain. I was trying to
use the same user for both, which I could have done had they been setup
correctly. I've been out of the SQL world for a couple years so dusting off
those cobbwebs is quite challenging at times.

Thanks you for all your help with this as your responses did aid in
rectifiying this issue.
Tony

"John Bell" <jbellnewsposts@xxxxxxxxxxx> wrote in message
news:OlvhD3T4JHA.1808@xxxxxxxxxxxxxxxxxxxxxxx
I would always use a file rather than a database to avoid it being a
bottleneck, in the same way I would use profiler!

This is what I have configured.
A System DSN, specifying windows authentication, and change to an existing
database when logged on.
Login an database tested through DSN and QA.
Perfmon counter created and uses log file to make sure it worked!
On the general tab, the user is set to Administrator for the local
administrator (.\Administrator also works!) and the password has been set.
On the Perfmon counter Log Files tab, SQL Database has been set, End File
names is un-checked.
Configuring the log file, choose the tested DSN as the System DSN

HTH

John

"Tony" <tsheehan@xxxxxxxxxxxxxxxx> wrote in message
news:%23N0IZLL4JHA.1380@xxxxxxxxxxxxxxxxxxxxxxx
Hi John,

I tried it on two servers, one was the SQL box and the other was one that
isn't currently used for anything. They are both Windows 2003 and I am
running a Windows 2003 domain. I've done this before at another location
but that was about 3 years ago so I am familiar with setting up the
counters and assigned them to be recorded via a DSN I created to the
database on SQL. The user account I created in SQL is an owner of the
database so writing to it shouldn't be an issue.

From what I can tell the problem has to do with the log in credentials,
which is evident from the error message. Maybe I need to call Microsoft?

Thanks,
Tony

"John Bell" <jbellnewsposts@xxxxxxxxxxx> wrote in message
news:647611AA-4681-40A9-AAC6-8D04B84F6656@xxxxxxxxxxxxxxxx
Hi Tony

Can you go through the steps you have used to create this? Have you made
this work on a different server?

John

"Tony" <tsheehan@xxxxxxxxxxxxxxxx> wrote in message
news:Oyqv6uH4JHA.1712@xxxxxxxxxxxxxxxxxxxxxxx
Hi John,

Unfortunately I don't have support but I can call if I can't figure it
out soon.

Here are the answers to your questions:
1. I am logged in with a domain account - mine, I'll try logging in
with the domain admin account.
2. Yes
3. No, I'd rather save this as a last resort.

Thanks,
Tony

"John Bell" <jbellnewsposts@xxxxxxxxxxx> wrote in message
news:OIYnZZH4JHA.4872@xxxxxxxxxxxxxxxxxxxxxxx

"Tony" <tsheehan@xxxxxxxxxxxxxxxx> wrote in message
news:OdCZtLH4JHA.1424@xxxxxxxxxxxxxxxxxxxxxxx
I continue to receive error 2059, which states "Invalid username or
password for the {Counter's name} log session. This session will not
be started."

I know the username and password are correct because I'm using the
Administrator account for it to "Run As;" if I use my personal
account I receive three additional errors that basically tell me they
don't know what the errors are.

I've added mine and the administrator's accounts to the "Performance
Log Users" group on the local computer, in Active Directory, and to
the local group on my SQL 2005 box.

I've look all across the Internet and cannot find the answer to this
problem.

Can anyone help me figure this out?

Thank you,
Tony Sheehan

Hi

This seems to be a rare error!!! It could be a case for PSS if you
have support. It does seem to be an authentication issue!!

Are you logged in with a domain or local account?
Have you tried domain admins as well as local admins?
Have you tired removing the machine from the domain and re-adding it?

John









.

Relevant Pages

  • Re: PerfMon recording to SQL 2005
    ... I've been out of the SQL world for a couple years so dusting off ... A System DSN, specifying windows authentication, and change to an existing ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
    (microsoft.public.sqlserver.server)
  • Re: PerfMon recording to SQL 2005
    ... I've been out of the SQL world for a couple years so dusting ... A System DSN, specifying windows authentication, and change to an ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
    (microsoft.public.sqlserver.server)
  • Re: PerfMon recording to SQL 2005
    ... seconds or even every ne second) from a busy server to a database on ... On the Perfmon counter Log Files tab, SQL Database has been set, End File ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
    (microsoft.public.sqlserver.server)
  • Re: Security Update for SQL Server 2005 Service Pack 2 (KB948109)
    ... through the latest log file Summary.txt under the directory C:\Program ... SQL Express Features: ... that the account and domain running SQL Server Setup exist, ... have the administrator permissions required to rename a file: C: ...
    (microsoft.public.windowsupdate)
  • Re: Security Update for SQL Server 2005 Service Pack 2 (KB948109)
    ... through the latest log file Summary.txt under the directory C:\Program ... SQL Express Features: ... that the account and domain running SQL Server Setup exist, ... have the administrator permissions required to rename a file: C: ...
    (microsoft.public.windowsupdate)