Sql Server agent configuration issue

Question

Sql Server agent configuration issue

Pergy

SSC-Addicted

Points: 409
More actions
September 29, 2008 at 9:26 pm

#193349

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

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

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

John H Marsh SSChampion Points: 11671 More actions · Answer 1

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

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 2

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;-)

Pergy SSC-Addicted Points: 409 More actions · Answer 3

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

Bijal Parekh Mr or Mrs. 500 Points: 575 More actions · Answer 4

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.

Bijal Parekh Mr or Mrs. 500 Points: 575 More actions · Answer 5

hi,

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

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

Pergy SSC-Addicted Points: 409 More actions · Answer 6

Hi,

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

Thanks

John H Marsh SSChampion Points: 11671 More actions · Answer 7

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

Pergy SSC-Addicted Points: 409 More actions · Answer 8

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

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 9

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;-)

paul.tormey SSC Journeyman Points: 92 More actions · Answer 10

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

Great set of tools.

Cheers

Paul