Express and Developer - performance counter errors

I installed Visual Studio 2005 on my machine, which includes SQL Server Express. I then installed the Developer edition of SQL Server over the top, as that's the edition I wanted. I now get four errors in my Application event log whenever I boot Windows:

MSSQLSERVER - Performance counter shared memory setup failed with error -1. Reinstall sqlctr.ini for this instance, and ensure that the instance login account has correct registry permissions.

MSSQLSERVER - Error in mapping SQL Server performance object/counter indexes to object/counter names. SQL Server performance counters are disabled.

MSSQL$SQLEXPRESS - Performance counter shared memory setup failed with error -1. Reinstall sqlctr.ini for this instance, and ensure that the instance login account has correct registry permissions.

MSSQL$SQLEXPRESS - Error in mapping SQL Server performance object/counter indexes to object/counter names. SQL Server performance counters are disabled.

Any idea what's causing this problem and how I can fix it?

Thanks

Here is one thing you can try.

Start Regedit

For a default instance of SQL Server, locate the following registry value in Registry Editor:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer\Performance\Library

For a named instance of SQL Server, locate the following registry value in Registry Editor:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQL$<Instance Name>\Performance\Library

If the registry key does not exist in Registry Editor, you must rebuild the registry. For more information about how to rebuild the registry to fix these registry errors, see the "How to rebuild the registry (Setup)" topic in SQL Server Books Online.

Michelle

|||

Hi there, I've only just noticed your reply so thanks for responding. I have removed the MSSQL$SQLExpress instance via Control Panel but I am still getting the error messages for the MSSQLServer instance.

I have looked at the registry entry you mentioned and it is present and is set to 'sqlctr90.dll'. Is that correct? If so, any further ideas?

Thanks

|||

Yes what you see is correct.

Check out the following thread as it has some other suggestions to try.

Michelle

|||Sorry Michelle but I can't see a link in your reply - could you tell me the thread title?

Thanks

Neil|||

Sorry I forgot to attach the link.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=158314&SiteID=1

Michelle