Re: PerfMon recording to SQL 2005

Hi Linchi,

Excellent advice!

Thank you,
Tony

"Linchi Shea" <LinchiShea@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EB67A058-6DBD-4143-ADD6-69FB38A6A6E2@xxxxxxxxxxxxxxxx
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 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
    ... 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)