The Process Could Not Be Created For Step 1 Of Job

Hi I am facing an issue running an SSIS package on a SQL Server 2005 SP2 machine



Here's more information:



1) The SSIS package that dumps data returned from a stored procedure call to an excel (CSV) file. The package owner is a SQL Login called AppAdmin. The login has user memberships/roles in two databases:



1.1) Database AppDB - Has execute and select permissions.

1.2) Database msdb - SQLAgentUser role



The package has one step that is run as a SSIS Proxy account PrxApp. The Proxy is based on a credential CrdApp which is based on a windows account <domain>AppAccount. This account is part of the Local Administrators group and also has SA rights in on the server. The same account is also used to run all the SQL Server Services on this machine. The machine is part of a 2-node cluster (A/P).



When I try to execute this package (as a schedule or one-off), I am getting the error mentioned in the Subject. I have checked a few posts using google and have acted upon as many suggestions that I possibly could (e.g. change this, change that...did not do any registry modification, etc). Many of these posts have been talking about changing local security policy and adding the user to several groups. Did that, but still does not work in a SQL Agent Job.



The account currently has the following rights (local security policy)



Act as part of OS
Perf. volume maint tasks
Lock pages in memory
Replace process level token


One thing that I did notice and don't know if that affects the issue is that the following groups (and SQL Logins) are missing from my Windows groups listing (Computer ManagementUsers and GroupsGroups). Note that this is a Windows 2003 machine.



(a) SQLServer2005MSSQLUser$<machine_name>

(b) SQLServer2005SQLAgentUser$<machine_name>



Now these groups (and logins in SQL Server) do exist on some other SQL2005 machines that I have checked to see what could be wrong.



Any help at all is greatly appreciated. If you need any more information please let me know.



Thanks

Shishir Khandekar