Friday, February 17, 2012

Error 22002

Hi!
This is my first time in this fourm!

I've got SQL Server Standrad Edition version 8.00.760 (SP3) on Windows 2K. I'm logged in with my domain account, which is member of sysadmin

I get
"Autostart server agent" but following error appearred:
"Error 22002: Reg Create key ex() returened error 5:Access is denied"

when I check for Autostart MSDTC in SQL Server properties.

Why? Any ideas?

Thanks for all helpWhat accounts (including their permissions) are being used for the mssqlserver, agent and dtc services ?|||Originally posted by rnealejr
What accounts (including their permissions) are being used for the mssqlserver, agent and dtc services ?

Mssqlserver service and agent have the same local admin account.|||What about dtc ? Also, when you say local administrator account, do you mean .\Administrator ? Have you rebooted/restarted all the services ?|||Originally posted by rnealejr
What about dtc ? Also, when you say local administrator account, do you mean .\Administrator ? Have you rebooted/restarted all the services ?

Yes, they are .\Administrator. I don't know which dtc account use. I donot know where to look for this account! I 'm rather new at this job!|||Look for the distributed transaction coordinator service.|||Originally posted by rnealejr
Look for the distributed transaction coordinator service.
Local system account
Allow service to interact with desktop|||Originally posted by rnealejr
Look for the distributed transaction coordinator service.
I succeded starting this servicve automaticlly in Contral Panel, Services.

Thanks for your time and help!

No comments:

Post a Comment