We have an As400 system that has program which executes batch files which resides on the SQL server 7.0 computer . Those batch files run SQL server jobs
using isql. The whole idea about this is when ever some jobs will run on As400 to populate some files the program will be called to execute the batch files which will run the sql jobs to populate sql tables. This process working fine. But now we have installed SQL 2005 and trying to move . Before actually moving I am testing by moving one job and the batch file and creating one test As400 program that will execute that batch file. The batch file uses SQLCMD to run a job. When I try to run that batch file locally it works fine. But when I am trying to execute that batch file remotely thru the AS400 program it doesn't work. If I include some non-sql command in that batch file and execute that batch file remotely it runs those commands but does n't execute the sql commands.
The user_id and password the remote command uses has all the appropriate rights. Also I changed the settings of the sql server (as per the msn guide) to accept remote commands. still it does n't work. Can any one please suggest something ? Thanks in advance for your help..
using isql. The whole idea about this is when ever some jobs will run on As400 to populate some files the program will be called to execute the batch files which will run the sql jobs to populate sql tables. This process working fine. But now we have installed SQL 2005 and trying to move . Before actually moving I am testing by moving one job and the batch file and creating one test As400 program that will execute that batch file. The batch file uses SQLCMD to run a job. When I try to run that batch file locally it works fine. But when I am trying to execute that batch file remotely thru the AS400 program it doesn't work. If I include some non-sql command in that batch file and execute that batch file remotely it runs those commands but does n't execute the sql commands.
The user_id and password the remote command uses has all the appropriate rights. Also I changed the settings of the sql server (as per the msn guide) to accept remote commands. still it does n't work. Can any one please suggest something ? Thanks in advance for your help..