Re: PerfMon recording to SQL 2005

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 ... 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
    ... 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
    ... database when logged 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: SQL 2005 express security issue
    ... I can't use Windows authentication because I can't control account creation in client machine, ... I can't control user attached to my database because it is his own machine, I can't set any file permission, so the last security measure is to use SQL authentication to protect my data. ... You do not have to use the "sa" account and it's not recommended using this account because every hacker knows that SQL Server has a built-in sysadmin account which is called "sa". ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2005 express security issue
    ... Ekrem Onsoy ... I can't use Windows authentication because I can't control account creation in client machine, ... I can't control user attached to my database because it is his own machine, I can't set any file permission, so the last security measure is to use SQL authentication to protect my data. ...
    (microsoft.public.sqlserver.security)
Loading