Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I had to reinstall the default server instance on one Windows 2008 R2 server.

I checked that the sql groups were cleaned and the registry keys cleaned before reinstalling.

After reinstalling, the sqlagent refused to start.

The only way to start the agent successfully was to add the agent user (domain user) to the group MSSQLUSER$<SERVER_NAME> $MSSQLSERVER

I attempted a repair. all the repair attempts failed with the following message: - and removed the user above from the SQL group.

The following error has occurred:

The process cannot access the file 'C:\Windows\SysWOW64\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll' because it is being used by another process.

Any further update fails due to the repair error (cumulative hotfix update 4).

The SQL server log shows the following:

Error: 18456, Severity: 14, State: 11
Login failed for user ''. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]

The user <user> is a domain user used both for the SQL Server database engine and SQL Server Agent services. The password never expires.

I tried to give the user SQL sysadmin rights, then Windows local admin rights without success. So I'm stuck. Looked over the web and didn't find any solution that match

Also tried to : kill the wmi processes locking sql server agent, and stop wmi services (failed).

Any suggestion would be greatly appreciated.

Christophe

share|improve this question
    
Have you seen this link? dbamohsin.wordpress.com/2011/09/06/… –  JNK Jan 19 '12 at 16:21
add comment

1 Answer 1

up vote 3 down vote accepted

This is a known problem with this particular DLL during the repair process. Copying and renaming the file seems to be a suggested work around - see:

http://connect.microsoft.com/SQLServer/feedback/details/576412/-the-process-cannot-access-the-file-c-windows-syswow64-perf-mssql10-50-mssqlserver-sqlagtctr-dll-because-it-is-being-used-by-another-process

share|improve this answer
    
Many thanks for your help as it worked and I could run the repair. I renamed the dll both in system32 and SysWow64. –  nopol Jan 23 '12 at 8:35
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.