Tuesday, March 27, 2012

Error when setting MSDTC to autostart

Hi!
I'm getting an error message when I try to set autostart MSDTC in Enterprise manager. This problem just suddenly appered.
Error message:
Error 22002: RegCreateKeyEx() returned error5, 'Access is denied'
I hope somebody can tell me what this is :)Ensure the account used to start SQL Server services and MSDTC have necessary privileges to access the registry key and server.

Also, if you're using the DOMAIN account that you are trying to run the SQL services under must also have privlages to that machine. You must add that account to the local machine, such as the admin group.

If possible to restart the services and BTW what is the level of SQL service pack?sql

No comments:

Post a Comment