/build/static/layout/Breadcrumb_cap_w.png

Connect to back end SQL DB

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

Answers (5)

Posted by: RichB 6 years ago
Second Degree Brown Belt
0
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

Posted by: airwolf 13 years ago
Red Belt
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. [;)]
Posted by: jmcelvoy 13 years ago
Second Degree Blue Belt
0
Ok, I remember that password. What is the DB or Instance name? Or what is needed to make the connection to the appliances?
Posted by: airwolf 13 years ago
Red Belt
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.

Comments:
  • Default password is box747 - matt.may 10 years ago
Posted by: dchristian 13 years ago
Red Belt
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]

Comments:
  • link dead...fyi - gargone 11 years ago
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ