August 3, 2007 at 1:40 pm
I have SQL Server 2000 running on a Win2000 Advanced Server. On a different machine (same domain), we're running the Cognos suite of BI products, also on Win2000 Advanced Server. There is a Win32Process on the Cognos machine that I need to run at the end of a monthly update process.
On the SQL machine, I have a DTS package that performs all updates. Part of that package calls the Win32Process located on the Cognos machine. It is called by using a share reference as follows: (\\209.22.250.31\cmm2_bin\option4.bat). When I open Enterprise Manager on the Cognos machine and manually execute the process, it runs fine. When I open EM on the SQL machine and manually execute the process, it fails on that step. Here is the error message:
"CreateProcessTask'DTSTask_DTSCreateProcessTask_1': Process returned code 1, which does not match the specified SuccessReturnCode of 0."
I have validated the sharename and the file existence. And although I've verified the permissions on the share, it sounds like a permissions issue to me. So, I have several questions:
1) When the SQL machine calls the Win32 Process on the Cognos machine through Enterprise Manager/DTS, where is the process attempting to execute? Of course, it SHOULD be on the Cognos machine...but how can I tell? There is nothing in the Event Logs of either machine, nor is there anything in the SQL server log.
2) If the process is attempting to run on the SQL machine, is there a way I can make it run on the Cognos machine? (maybe by developing an ActiveX EXE program, install that on the Cognos machine and have it run the Win32 process when called by the DTS package)
3) Permissions...I'm using a domain account with admin privileges to run the DTS via EM. The account has fully control on the target share. Any other ideas relative to permissions?
Thanks!!!!!
August 4, 2007 at 11:01 am
"When the SQL machine calls the Win32 Process on the Cognos machine through Enterprise Manager/DTS, where is the process attempting to execute?"
The process is running on the SQL Server - the Cognos server is acting a file server.
MS Windows does not provide support for remote execution but there are a number of open source services available.
See http://www.codeproject.com/system/remoteexec.asp?df=100&forumid=14084&exp=0&select=1287957
SQL = Scarcely Qualifies as a Language
August 6, 2007 at 12:22 am
The process is executing on the local machine, the UNC you're using \\209.22.250.31\cmm2_bin\option4.bat is nothing more than a link network share - not a call to execute the code on another machine.
If you need to kick off a process on another windows machine REXEC from the appropriate resource kit may work for you.
Joe
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply