[sims] Command Reporter on Hosted SIMS

[CMiller]

I'm trying to use the CommandReporter, but failing at the first hurdle.

I can't get it to authorize against my hosted service. If I do not provide Server name and Database name, it instantly fails. If I provide these details (grabbed from connect.ini) - it times out looking for the server.

 

I believe it is a formatting issue, as the instant fail returns an error like "Login failed for user School_Name_Here_SchoolCode_UserName" (which I believe to be an incorrect username), and the timeout error complains about not being able to find the server, though I can ping it so I believe it is to do with the formatting of including the port number.

 

Here's the command i'm running so far. I'm testing so haven't specified an output file yet.

 

Has anyone successfully used CommandReporter with the hosted service? Can you give me any hints? I've got a ticket open with Capita, but we all know what their "4 Hour" SLA is like...

 

Any help would be massively appreciated.

[SID6581]

Sorry for the late bump but did you manage to get CommandReporter to work with hosted SIMS after?

[robinsahlot]

You will need to use Third Party Connector (VPN) to be able to establish a successful connection to the database.