Launching an app in another server's process space...

What I need to do is the following...

Server1 has an SQL db to which requests are submitted into a queue.

Server2 has the .exe's that are to be executed.

The client submits a request to server1 to have 1.exe and 2.exe run with some parameters.

I want server1 to launch 1.exe to run in server2's process space.  What is the proper and approved way to do this?  I know I could whip up a little service that would run on server2 and wait for requests to run .exe files, but that doesn't seem like a clean way to me.  What is the proper way to do this?  Effectively I don't want server1 to be running any of these .exe files.  (the .exe files are reports that are processor intensive and they fight with sqlservr for processor time).

Thanks.
LVL 1
timberbtAsked:
Who is Participating?
 
jhanceConnect With a Mentor Commented:
Unless you want to build this capability from the ground up (and I doubt you want to do so as it's a lot of work to make it both right and secure) you have two basic options:

1) RPC
2) DCOM

Both are rather complex topics in light of a 50 pt question but both have many examples and sample applications in the Microsoft documentation and many other web sites.

If you app uses COM already, DCOM is a relatively easy extension.  Otherwise, RPC is more general in it's application but you don't have the COM subsystem to hide the complexity.
0
 
timberbtAuthor Commented:
Understood.... I wasn't looking for anything above and beyond the call of a 50pt question really.  Just what to look at was really all I needed...


Does everyone else concur that these would be the "proper" way of handling this sort of thing?  

Thanks Jhance.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.