April 3, 2008 at 2:38 pm
I signed on as 'sa' that meant I had sysadmin right but it still refused to let me create a job.
It said ' Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'
Please help !!!
I hate SQL Server 2005!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!:crazy:
April 4, 2008 at 8:31 am
Do you have SP2 installed?
I have been researching this error today, there's not much info out there. Some people say applying SP2 fixes the problem, I already have SP2 installed and am still getting the error. I'm getting grumpier...
April 4, 2008 at 8:56 am
I have SP2 installed and did not have any issue creating a job in SSMS. Have you tried creating a job using the job creation SP's directly?
Are you having problems with another login assigned to the sysadmin server role?
Grumpy,
Please post your findings, if you have any.
Thanks,
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 4, 2008 at 9:34 am
Sounds like you're missing some DLLs, maybe a corrupt installation
April 4, 2008 at 12:52 pm
are you trying to create a job from different computer? If yes then I am sure you have client tools on that system with Service Pack 1. upgrade client tool to sp2 will resolve problem.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
April 4, 2008 at 3:07 pm
Installed SP2 and it worked. Thanks
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply