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.
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.
CodeProject
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.
CodeProject
No comments:
Post a Comment