Connect to back end SQL DB

Question

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\???

Answer

Here is the current location of that article "

Can I access the K1000 Appliance database using a third-party reporting tool? (114992)"

: https://support.quest.com/kace-systems-management-appliance/kb/114992

Answer

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. [;)]

Answer

Ok, I remember that password.  What is the DB or Instance name?  Or what is needed to make the connection to the appliances?

Answer

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.

Answer

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]