SSIS job schedular issue
Hi, i am facing the below error while scheduling and running the ssis packages. i created a proxy account and am running my packages through it. Last two to three months it went well and now it is not working and throws the below error. [298] SQLServer Error: 14516, Proxy (1) is not allowed for subsystem "SSIS" and user "sa". Grant permission by calling sp_grant_proxy_to_subsystem or sp_grant_login_to_proxy. [SQLSTATE 42000] Please help me on this.
July 18th, 2012 5:32am

You need to grant permission to subsystem. Refer this http://msdn.microsoft.com/en-us/library/ms186760.aspx Hope this helps.
Free Windows Admin Tool Kit Click here and download it now
July 18th, 2012 5:39am

HI when i try to give the access it says the permission already exists for sysadmins. i even tried of revoking the proxy access and then grated the access. still facing the same issues. please help me on the same.
July 18th, 2012 5:43am

check whether the user under which the sql agent is running on the server is changed or not (under services.msc). maybe the user used in the principal that you are using for the proxy account is no longer has access to sql engine. regards joon
Free Windows Admin Tool Kit Click here and download it now
July 18th, 2012 5:51am

Hi The sqlserver agent is running in the automatic mode. It runs under local system account. The proxy is given a credential of the local administrator.
July 18th, 2012 5:59am

can you try using the normal SQL Server Agent Service Account instead of the proxy. And where have you deployed the package, to the sql server or file system? If it is SQl server, then it should work. If file system, maybe you can the file location and user access to that folder of the deployed package. regards joon
Free Windows Admin Tool Kit Click here and download it now
July 18th, 2012 6:11am

Hi, I have changed the account run as SQL server agent service account, i didnt get any error but the job is keep on running without any information or error or warning. i have deployed the package in the filesystem. please help me on this.
July 18th, 2012 7:29am

HI, Even after changing the proxy account to sqlserver agent service account, the packages are not running as scheduled. If manually ran from the sqlserver also its not running, can anyone plz help me out of this issue. Thanks in advance.
Free Windows Admin Tool Kit Click here and download it now
July 18th, 2012 8:25am

Any one plz help with the issue ??????????????
July 18th, 2012 8:38am

Hi, Rthis script in SSMS, after that try recreating the job again..... USE msdb ; GO EXEC dbo.sp_grant_login_to_proxy @login_name = N'xxx\xxxxx', @proxy_name = N'ProxyName' ; GO
Free Windows Admin Tool Kit Click here and download it now
July 18th, 2012 8:42am

Hi, if i use a proxy account it throws error like below [298] SQLServer Error: 14516, Proxy (1) is not allowed for subsystem "SSIS" and user "sa". Grant permission by calling sp_grant_proxy_to_subsystem or sp_grant_login_to_proxy. [SQLSTATE 42000] if i try to give login access to sa it says it already has access. i tried deleting the proxy and recreating it and then tried executing the packages, again i got the same error i changed the executing account as sqlserver agent service account , it didnt throw error but didnt run also. please help me on the same
July 18th, 2012 8:49am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics