Results 1 to 8 of 8

Thread: Error 22002

  1. #1
    Join Date
    Oct 2003
    Location
    Sweden, Stockholm
    Posts
    14

    Unanswered: 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 help
    /*
    Fari Sah
    */

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    What accounts (including their permissions) are being used for the mssqlserver, agent and dtc services ?

  3. #3
    Join Date
    Oct 2003
    Location
    Sweden, Stockholm
    Posts
    14
    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.
    /*
    Fari Sah
    */

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    What about dtc ? Also, when you say local administrator account, do you mean .\Administrator ? Have you rebooted/restarted all the services ?

  5. #5
    Join Date
    Oct 2003
    Location
    Sweden, Stockholm
    Posts
    14
    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!
    /*
    Fari Sah
    */

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    Look for the distributed transaction coordinator service.

  7. #7
    Join Date
    Oct 2003
    Location
    Sweden, Stockholm
    Posts
    14
    Originally posted by rnealejr
    Look for the distributed transaction coordinator service.
    Local system account
    Allow service to interact with desktop
    /*
    Fari Sah
    */

  8. #8
    Join Date
    Oct 2003
    Location
    Sweden, Stockholm
    Posts
    14
    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!
    /*
    Fari Sah
    */

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •