GeekZilla
Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey'
I was getting the following error when I attempted to create a new job in SQL Server Agent:
Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)
Nothing I did improved the situation. It then occured to me that it may not be an issue if I Terminal Severed onto the actual SQL Server.
Presto! It worked and my job was created.
What this complicated error message meant in my case was... "Log onto the box and do it"
I hope you manage to create your job.
Ric is an MCPD Microsoft Certified Professional Developer with over 25 years commercial development experience using Microsoft technologies.
Comments
Scott Taylor said:
You're awesome. Worked perfectly by logging into the sql server. Thanks.
Daniel said:
Thank you for your interpretation. So much easier to understand.
Polelo said:
Magic!