Trying to automate a SQL Task that will execute a Report using Report Commander from another location, the user won't be logged onto the Server

Instead of C:\Program Files\Arcana\Report Commander\adcrutil.exe

I need to use  \\wpi\c$\Program Files\Arcana\Report Commander\adcrutil.exe

Is there a way to do this?

 

 

We use a UNC all the time. (\\MACHINENAME\SHARENAME)  The one you showed may not work as the C$ share may be restricted to just System Admins. We use a product called WinBatch and create batch type files on the server calling Report Commander from a batch file. We then use the Windows Scheduler to run the batch files. We call out to multiple servers where ever the report is and to where ever we want the output to go. We have many Crystal Reports that we automate using Report Commander that run every day.

Hope this helps.

 

You can use a UNC path to specify the report source or the export file name, that's what cshaner is talking about, but you can't use it the way you're talking about, to run the Report Commander program from one computer when it's installed on a different computer. If you want to run it from a SQL task then Report Commander has to be installed on the same computer or you have to investigate the use of a remote shell tool or something like that that can cause Report Commander to execute on the computer where it's installed.