SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Sql Server agent configuration issue


Sql Server agent configuration issue

Author
Message
Pergy
Pergy
SSC Veteran
SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)

Group: General Forum Members
Points: 235 Visits: 80
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
John H Marsh
John H Marsh
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10573 Visits: 1472
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
Bhuvnesh
SSC Guru
SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)

Group: General Forum Members
Points: 53118 Visits: 4079
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
Pergy
SSC Veteran
SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)

Group: General Forum Members
Points: 235 Visits: 80
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
Bijal Parekh
Mr or Mrs. 500
Mr or Mrs. 500 (557 reputation)Mr or Mrs. 500 (557 reputation)Mr or Mrs. 500 (557 reputation)Mr or Mrs. 500 (557 reputation)Mr or Mrs. 500 (557 reputation)Mr or Mrs. 500 (557 reputation)Mr or Mrs. 500 (557 reputation)Mr or Mrs. 500 (557 reputation)

Group: General Forum Members
Points: 557 Visits: 352
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
Bijal Parekh
Mr or Mrs. 500
Mr or Mrs. 500 (557 reputation)Mr or Mrs. 500 (557 reputation)Mr or Mrs. 500 (557 reputation)Mr or Mrs. 500 (557 reputation)Mr or Mrs. 500 (557 reputation)Mr or Mrs. 500 (557 reputation)Mr or Mrs. 500 (557 reputation)Mr or Mrs. 500 (557 reputation)

Group: General Forum Members
Points: 557 Visits: 352
hi,
this was the kb article i referred to when i encountered the problem :

http://support.microsoft.com/kb/907739
Pergy
Pergy
SSC Veteran
SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)

Group: General Forum Members
Points: 235 Visits: 80
Hi,

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

Thanks
John H Marsh
John H Marsh
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10573 Visits: 1472
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 Wink

Regards,

John Marsh

www.sql.lu
SQL Server Luxembourg User Group
Pergy
Pergy
SSC Veteran
SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)

Group: General Forum Members
Points: 235 Visits: 80
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
Bhuvnesh
SSC Guru
SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)

Group: General Forum Members
Points: 53118 Visits: 4079
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 Smile

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


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search