SSIS ,Executing via SQL Server Agent fails
Hi , I have a 2 JOBS in SQL Server agent . 1.JOB Exceuting a Stored Proceedure 2.Executing an SSIS Package When i Run JOB 1 It ran very well and job was Successful , but when I run the SSIS Package under SQL Server Agent .it Fails and throws me an Login failed . But when i go to the package and run it manullay it RAN Sucessfully , Note: I used SQL SERVER AUTHENTICATION at SSIS package while connecting to Database. I am having SA Account .... Can you please tell me why cant i Exceute the SSIS package Under SQL Server Agent .
February 28th, 2011 10:46am

Running it manually frim BIDS? What are the resourcs being used in the package? Are any folders or other data bases being used? If thats the case(most likely) you need to run the package using proxy account with previleges to the resources used.My Blog | Ask Me
Free Windows Admin Tool Kit Click here and download it now
February 28th, 2011 11:04am

You need check your SQL Agent services account , does it have rights to exec on the server? If you think my suggestion is useful, please rate it as helpful. If it has helped you to resolve the problem, please Mark it as Answer.
February 28th, 2011 11:04am

SQL Agent Service might not have enough permissions on the packages and folders. If the packages accessing any folders you must give the service account to access those folders.
Free Windows Admin Tool Kit Click here and download it now
February 28th, 2011 11:17am

I tried connecting to my server using 00.00.0000 (name) when i tried using Instance name it ran succesfuly Thanks for your help
February 28th, 2011 2:05pm

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

Other recent topics Other recent topics