March 9, 2009 at 6:46 am
Hi,
When I create a job on sql server 2005 standard edition,I receive the following error:---
Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)
Please guide me to resolve the above error.
Thanks,
Sunil.
March 9, 2009 at 6:51 am
Are you >= SP2? Also, did you try creating the job on the server itself (remote desktop to server) using SSMS (client) on the local sql server?
March 9, 2009 at 6:55 am
Yes I am creating a backup job on remote desktop to server. And SP2 is already installed.
March 9, 2009 at 7:02 am
Are you getting error when creating or executing the job? Does your account running SQL agent have access to run/create jobs? (Local System account, or user in a group with permissions to filesystem and sysadmin db role, etc...).
March 9, 2009 at 7:33 am
What type of security are you using? What role are you in when you try to create the jobs?
If windows mode is being used are you an administrator on the machine?
I suspect you do not have authority to create jobs.
March 9, 2009 at 7:52 am
Yes I get the error when I create the Job.
March 9, 2009 at 12:36 pm
Found this post on MSDN that might be of help...http://social.msdn.microsoft.com/Forums/en-US/sqlsmoanddmo/thread/79281b89-d305-44cc-9568-5dcff4620196/
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 9, 2009 at 4:07 pm
Your not on a cluster node are you ? i had this error when my sql rolled over to its standby and i couldn't edit a job...so i had to go onto the physical node ...
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply