This article only applies to Squared Up Version 2.0. If you're looking for help with Squared Up Version 3.0, please visit our new knowledge base
Here are a few things to check if you're finding the SQL plugin shows no data.
1. Test the query in SQL Server Management Studio
Run the query in SQL Server Management Studio on the SQL server. Are results shown? If not, then there is a problem with the query.
2. Check Squared Up has access to this database
By default, access to the data warehouse database is configured following the Squared Up installation process, but you will need to configure access to any other database. Check that the the Squared Up application pool account has the 'apm_datareader', 'db_datareader' roles on the database that the SQL is querying. See Configuring access to a database for use with the SQL plugin.
It is important to note that the account you are logging into Squared Up with has no effect database access. What is important is the user (identity) of the application pool inside IIS which is being used by Squared Up.
3. Check the connectionstring
In Squared Up under Advanced settings for the SQL section check the connectionstring:
|Database||Connection (Connection String)|
If the Squared Up server and SQL server are in the same domain:
If the Squared Up server and SQL server are not in the same domain:
If the OperationsManager database is on the same server as the data warehouse you can use:
and then put the following at the beginning of the query:
|Any other database|
|Using an instance|
Specifying a port
4. Check whether the display should be scalar or tabular
In the 'options' section of the SQL plugin check the 'display' setting. Scalar should be used if only one figure is returned by the query. Tabular should be selected if a table of information is returned.
If you still experience problems please send the result of the Squared Up Diagnostics Script, a screenshot of the SQL plugin configuration and a copy of the SQL query text and to firstname.lastname@example.org