April 15, 2016 at 8:34 am
Hi guys,
I get this error after changing sql server service account from LocalSystem to a domain account (SQL 2008).
"Windows kernel object 'Global\SQL_90_MEMOBJ_MSSQLSERVER_0' already exists. It's not owned by the SQL Server service account. SQL Server performance counters are disabled.
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.
Perfmon counters for resource governor pools and groups failed to initialize and are disabled."
I have followed the steps below when changing service acc:
Added to local policies:
Act as part of the operating system
Bypass traverse checking
Lock pages in memory
Logon as a batch job
Logon as a service
Replace a process level token
Adjust memory quotas for a process.
Perform volume maintenance tasks. (Instant file initialization)
The service account has been added to the following
1. In administrator group
2. In SQLServerMSSQLUser $<ServerName> $<instanceName>
3. In SQLServerSQLAgentUser $<ServerName> $<instanceName>
4. In all the local policy mentioned above
5. Full control on data, log, temp db and backup drive letters.
6. Full control for Mssqlxxxx folder under c:program files
7. Log on and log off the server with the new SQL Server Domain Account .
8. change the service account on configuration manager for all the services and restart the sql services.
Any thoughts on this? When the windows server is restarted, I don't see this error.
Many thanks
April 17, 2016 at 10:42 pm
You could try running a unlodctr/lodctr on sqlctr.ini to see if that helps. Another suggestion: http://www.sqlservercentral.com/Forums/Topic424661-146-1.aspx
April 18, 2016 at 4:39 am
SQL!$@w$0ME (4/15/2016)
Hi guys,I get this error after changing sql server service account from LocalSystem to a domain account (SQL 2008).
"Windows kernel object 'Global\SQL_90_MEMOBJ_MSSQLSERVER_0' already exists. It's not owned by the SQL Server service account. SQL Server performance counters are disabled.
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.
Perfmon counters for resource governor pools and groups failed to initialize and are disabled."
I have followed the steps below when changing service acc:
Added to local policies:
Act as part of the operating system
Bypass traverse checking
Lock pages in memory
Logon as a batch job
Logon as a service
Replace a process level token
Adjust memory quotas for a process.
Perform volume maintenance tasks. (Instant file initialization)
The service account has been added to the following
1. In administrator group
2. In SQLServerMSSQLUser $<ServerName> $<instanceName>
3. In SQLServerSQLAgentUser $<ServerName> $<instanceName>
4. In all the local policy mentioned above
5. Full control on data, log, temp db and backup drive letters.
6. Full control for Mssqlxxxx folder under c:program files
7. Log on and log off the server with the new SQL Server Domain Account .
8. change the service account on configuration manager for all the services and restart the sql services.
Any thoughts on this? When the windows server is restarted, I don't see this error.
Many thanks
You shouldn't have to make any changes, ensure you change the account details via SQL Server Configuration manager
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply