The stored procedure itself will run on a Windows 2003 Server (SQL 2005).
The script should connect to a Solaris 10 (UNIX) box to execute some commands.
>
> The stored procedure itself will run on a Windows 2003 Server (SQL 2005).
> The script should connect to a Solaris 10 (UNIX) box to execute some commands.
>
So, then the easiest way will be to write and put shell script on the UNIX box, then the stored procedure should just call rsh/ssh client and execute the script.
Sure, you should (1) install some windows port of rsh/ssh on win2003 system, and (2) make arrangements for the non-interactive login (e.g., non-password protected ssh private key on win2003 system, or some rhosts assignments on the solaris system - of course, the environment should be secure enough). My advice would be to go with ssh - not because of encryption and security, unattended login should create security hole anyway, but because of ease of setup: rsh is a protocol quite tricky for firewalls.
BR and good luck,
Petko
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: 4  Replies