Sql Server agent configuration issue

  • Hi Guys,

    The issue I have is that I cannot alter the configuration on SQl Server agent. When I right click the agent, change a setting and click OK, I get an error shown below

    Alter failed fo Job server 'xxxx\xxxx' (Microsoft.SQl server.smo)

    Additional information

    An exception occurred while executing a Transact-SQl statemnet or batch.

    (Microsoft.sqlserver.connectioninfo)

    regcreatekeyEx() returned error 5 'access is denied'

    regcreatekeyEx() returned error 5 'access is denied' (Micorsofft SQl server, error:22002)

    I have full permission in the domain, full permission on the physical server where SQl 2005 is located and I have sysadmin access in sql2005. I can stop and start the agent and do all the necessary changes in the agent (example, add a job). I have also added my account to SqlAgentOpertorRole but no luck.

    I cannot seem to find the solution but I got a feeling it could be something simple but I just cannot see it.

    Has anyone had this problem before.

    thanks

  • Hello,

    The following thread suggests the issue might be related to the Service Account that SQL Agent is running under, rather than your account: http://www.dbforums.com/showthread.php?t=1631567

    Is the Agent Service Account a domain account? Does it have administrator privileges in Windows? If not, then may be temporarily try using an Admin account and see if it works that way.

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

  • Restart your SQL server Agent ....you problem will be sorted out

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • Guys,

    The Sql Service account is a domain account and the account is a local administrator also (for testing purposes

    ). I have also logged onto SQL2005 using the SQL Service Account but not luck. I have used my admin account but still no luck and I have restarted the agent on a numerous occasions.

    I think the next step could be phoning Microsoft

    Thanks

  • Hi,

    Have you registered a sql server 2000 instance in sql server 2005 and are trying to edit the properties of that instance. I have encountered a similar problem when i tried to edit the properties of a sQL Server 2000 instance from SSMS.

  • hi,

    this was the kb article i referred to when i encountered the problem :

    http://support.microsoft.com/kb/907739

  • Hi,

    this issue has not got anything to do with SQL 2000 instances.:)

    Thanks

  • Hello,

    "I think the next step could be phoning Microsoft"

    It's looking that way. Please post the resolution, as it could help somebody else in the future i.e. me 😉

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

  • Hi Guys,

    I seem to have found the problem, the lady from Microsoft helped me to solve this problem, she was senational.

    Below is the method

    "It appears that the permission in some registry keys is even not granted to the local admin account on your side. Generally, to further troubleshoot the issue, I will suggest that you use Process Monitor to collect the file/registry usage when repro the "OS Error 5 – Access is denied":

    Process Monitor v1.35

    http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx

    How to use it

    ================

    1. Open Process Monitor to start the log collection

    2. Perform the change/operation in Management Studio

    3. When you got the same OS error 5, click Capture button to stop the log collection

    Then, you can check the captured log to see which necessary permission is missing for that account. "

    I found the reg key and added the SQL service Account. Restarted the Agent and now all works.

    hope this helps someone else.

    Thanks

  • hi...it was great to look into the solution provuded by that lady.but can you tell me PROCESS MONITOR is a third party tool or something else.

    and can you tell me exact words of ERROR which you found inthis problem i just wanted to document it 🙂

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • Sysinternals tools are part of Microsoft. Look back at the earlier download URL.

    Great set of tools.

    Cheers

    Paul

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply