A while back a technician told me there was a way to load some tools and connect to the backend SQL DB of my K1000 & K2000. I didn't write down how to do this. Said this was a way to connect to it and play around without affecting anything in Production. Are there SQL tools that will do this and if so, what is the Instance name I'd need to connect to? Do I need the SA password? My k1000 is named HelpDesk so I'd connect to HelpDesk\???
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
http://dev.mysql.com/downloads/workbench/5.2.html

You configure the remote password in the KBOX server configuration. Don't worry about breaking anything, because remote connectivity to the DB is read-only. However, it is possible to run queries that will bog the system down so much that you're basically performing a DoS attack against yourself. You have been warned. [;)]
Answered 02/15/2011 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
Ok, I remember that password. What is the DB or Instance name? Or what is needed to make the connection to the appliances?
Answered 02/15/2011 by: jmcelvoy
Second Degree Blue Belt

Please log in to comment
0
The username is R1 (if you only have one organization), and the default schema is ORG1 (again, if you only have one organization).

If you have more than one organization, just change the username and schema numbers by 1 for each ORG - i.e. R2 & ORG2, R3 & ORG3, etc.
Answered 02/15/2011 by: airwolf
Tenth Degree Black Belt

  • Default password is box747
Please log in to comment
0
Maybe this will help, its the article from the support site on how to connect.

[link]http://www.kace.com/support/kb/index.php?action=artikel&cat=9&id=9&artlang=en[/link]
Answered 02/15/2011 by: dchristian
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity