Unable to create a SQL Job in my local machine

Error while creating a SQL Job in local SQL Server DB Instance.

I got below error when I try to create a SQL job in SQL Server 2005 Instance.

Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. 

When i check for a fix, i see lot of users asking to uninstall and install the SSIS, but that does not resolve this issue.

This happens on 2 reasons.

1. If we don't have latest service pack installed (SP3) in your machine.
2. If we try to run the job with SQL Agent service account and that does have privilege to execute a SSIS package.

you can check the below code project link, which helps to create a proxy account for you domain account, using that you can run the job. 

Hope this helps.

No comments:

Post a Comment