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)

Data Warehouse

OperationsManagerDW

global:dw

OperationsManager database

Data Source=<server-name>;Initial Catalog=<database-name>;Integrated Security=True;


If the Squared Up server and SQL server are in the same domain:

Data Source=SQLServer1;Initial Catalog=OperationsManager;Integrated Security=True;

If the Squared Up server and SQL server are not in the same domain:

Data Source=SQLServer1.mydomain.local;Initial Catalog=OperationsManager;Integrated Security=True;


If the OperationsManager database is on the same server as the data warehouse you can use:

global:dw

and then put the following at the beginning of the query:

USE operationsmanager;

Any other database

Data Source=<server-name>;Initial Catalog=<database-name>;Integrated Security=True;

For example:

Data Source=SQLServer1;Initial Catalog=CRMDB;Integrated Security=True;

Using an instance

Data Source=<server-name>\<instance name>;Initial Catalog=<database-name>;Integrated Security=True;

Specifying a port

Data Source=<server-name>,<port number>;Initial Catalog=<database-name>;Integrated Security=True;

For example:

Data Source=SQLServer1,51433;Initial Catalog=CRMDB;Integrated Security=True;


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 support@squaredup.com


See also:

Configuring access to a database for use with the SQL plugin

How to configure the SQL plugin

Error: A network-related or instance-specific error occurred while establishing a connection to the SQL server