Command Reporter with Hosted SIMS

[syan]

How is everyone working CLR in hosted environments? Our school is new to both it and SIMS. I've downloaded the CommandReporter Utility 5.2 spreadsheet available from ESS but does it need to be run in the third-party connector machine (this is our SIMS server where CommandReporter.exe is located). If so is it possible to output the report, once run, into my local desktop somewhere so it can sync with Power Query, Power BI etc.?

[3s-gtech]

I think that as part of the work a VPN has to be set up between the hosted server and your own, to run Commandreporter.

[RLR]

We have a local version of sims installed on a sever that has a vpn connection to our sims hosted supplier (scomis).

[Edu-IT]

How is everyone working CLR in hosted environments? Our school is new to both it and SIMS. I've downloaded the CommandReporter Utility 5.2 spreadsheet available from ESS but does it need to be run in the third-party connector machine (this is our SIMS server where CommandReporter.exe is located). If so is it possible to output the report, once run, into my local desktop somewhere so it can sync with Power Query, Power BI etc.?

You could export it to a location that is mapped on your machine and the third party VPN machine, yes.

[syan]

So, I’ve mapped the server drive to my local machine fine and populated the following fields in the CLR utility:

 

User name of SIMS user with permission to run reports

Password of SIMS user with permission to run reports

Location of CommandReporter.exe

Server name\Instance

Database name

Save output files to

 

However when I try to get parameters I’m met with this error:

 

Login failed for user . Reason: A netwo

rk-related or instance-specific error occurred while establishing a connection t

o SQL Server. The server was not found or was not accessible. Verify that the in

stance name is correct and that SQL Server is configured to allow remote connect

ions. (provider: Named Pipes Provider, error: 40 - Could not open a connection t

o SQL Server)

 

I’ve gone into SQL Server Configuration Manager and doubled-checked TCP/IP is enabled (which it is) and have enabled IP1 – our server IP (the rest are disabled) but it returns the same error. I’ve left instance/database fields blank as well but still same error. I’m not IT (data here) but maybe worth mentioning that the server and database name in connect.ini is different from the system information in SIMS. Will log with ESS but any ideas in meantime?

[Edu-IT]

Is this on the third party connector machine and have you pointed it at the hosted database IP address / instance and used a username/password you've created in SIMS?

[syan]

Is this on the third party connector machine and have you pointed it at the hosted database IP address / instance and used a username/password you've created in SIMS?

 

Our local SIMS server is our TPC. Am running utility on local machine. Username points to user created in SIMS, location of commandreporter.exe points to Program Files (x86)\SIMS\SIMS.net folder via mapped drive to server/TPC, server instance/database name point to exactly what is stated in system info in our Hosted SIMS (SQL Server name: , Database name: ). Am I missing something?

[NotSoFast]

I never got it running on my own machine. We have it running on the server itself, which I go onto if I need to edit the batch files/scheduled tasks (almost never).