Re: PerfMon recording to SQL 2005

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: Connect problem MSDE ADO ASP
    ... problems on setting the IIS User password. ... result - and both can access the MSDE SQL via the webinterface (I am aware I ... > your connection string, and put in a valid SQL USER ACCOUNT, not a Windows ...
    (microsoft.public.sqlserver.programming)
  • RE: Integrated Authentication (Kerberos) Problem
    ... Verify the SPN for the SQL service account is registered such as the ... >Thread-Topic: Integrated Authentication Problem ... A Windows XP SP1 with IE6 client machine ...
    (microsoft.public.inetserver.iis.security)
  • Re: User authentication
    ... I was able to change the owner of a backup to the backup operator (Windows ... account) on a backup job configured on SQL Agent, ... If I set a backup job on SQL Server Maintenance Plan on SQL Server 2005, ... I am not able to assign the job to a different Windows account. ...
    (microsoft.public.sqlserver.clients)
  • Re: User authentication
    ... I was able to change the owner of a backup to the backup operator (Windows ... account) on a backup job configured on SQL Agent, ... If I set a backup job on SQL Server Maintenance Plan on SQL Server 2005, ... I am not able to assign the job to a different Windows account. ...
    (microsoft.public.sqlserver.clients)
  • Re: Delegation problems
    ... What account is running SQL? ... appropriate SPNs. ... then it depends on how you are connecting to SQL. ... I have several other servers running SQL and the SQL ...
    (microsoft.public.dotnet.framework.aspnet.security)
Loading