To be able to connect you first need a license for accessing your data remotely. to do that, just write to firstname.lastname@example.org, and within 48 hours, you will receive an email with Username, password and datashource. Please include the IP address from where you want to have access.
So now you have the license, what to do next? This walk-through is based on Microsoft SQL server Management Studio, but the steps should be the same for other applications (e.g. Microsoft Excel).
1. Open Management Studio
To open the management studio search for Microsoft SQL Server Management Studio or find the Icon
Click on it and Management studio will open.
Note, If you dont have Management studio, then click here to download.
when you have opened the application, it should look like this:
In the connect box enter the information that you received by email:
- Servername. remember Port number. IP and port must be seperated by Comma.
After you have entered this, then click Options (if you forget this, then you can't Login) and enter SQLPowerhouse in Connect to database.
If you have succeeded then the object explorer in the left side looks like this:
3. Expand Object types (e.g. Views).
Click on databases and Views (or Programmability --> Stored Procedures), and you will see the objects you can query:
(Please note. This list will change over time).
4. Query the data
Right click Data.vStatusWaitsHour and choose Select 1000 rows.
You will see an autogenerated query and the result. If not, then you have a problem, and you should search our knowledgebase and/or contact support on email@example.com.
If you could query the data, then you have access to your performancedata, and you have setup everything correctly.