I am testing database migration from SQL Server 2000 to SQL Server 2005. It's SQL Server 2005 64-bit running on Windows Server 2003 64-bit OS.
I have a SQL Server Agent job that copies data from all different sources, and at the last step it will invoke a Win32 executable to process the data. I have set up the OS Environment and Windows registry, and I have no problem running the executable manually or through Windows Scheduler.
However, when running the SQL Server Agent scheduled job, the job hangs. When I check Event Viewer, it says "Unable To Locate Component : This application has failed to start because xxx.dll was not found.". In fact, the xxx.dll is right under the same folder.
The user running SQL Server and Agent is in the local administrator group. If I log in to the server as this user, I have no problem running the executable manually.
Does anyone have any idea why this is happening? Is this SQL Server issue or Windows Server issue?
Any help will be very appreciated!