November 6, 2009 at 9:46 am
I'm getting this error message when trying to create a new job.
Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)
I Googled it, and that lead me to this: http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx
Which seems like the right answer, but when I'm trying to setup an account with the appropriate privileges, I don't have the required server roles "SQLAgentUserRole, SQLAgentReaderRole, SQLAgentOperatorRole" as options.
What to do? Is there another/better way? This seems overly complicated for simply scheduling a *.dtsx package.
November 6, 2009 at 9:54 am
Those aren't server roles. Those roles are Database roles within the MSDB database. You will need to grant the user access in the msdb database and then add that user to the necessary roles in the msdb database.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 6, 2009 at 10:03 am
My database roles list also does not list "SQLAgentUserRole, SQLAgentReaderRole, SQLAgentOperatorRole" as options.
Here are my options in the database roles list: accessadmin, backupoperator, datareader, datawriter, ddadmin, denydatareader, denydatawriter, owner, securityadmin
November 9, 2009 at 9:08 am
This thread suggests upgrading to SP2 will resolve this issue:
http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/e7c0e73e-8d4b-4624-a19e-352a69995f9e/
Come to find out we're not running SP2...I'll let you know if that fixes the issue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply