Troubleshooting the SQL tile
In this article:
If you are having problems using the SQL tile to add SQL queries into Dashboard Server please check the following:
Here are a few things to check if you're finding the SQL tile shows no data.
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.
Check Dashboard Server has access to the database being queried.
By default, access to the Data Warehouse database is configured during the Dashboard Server setup process, but you will need to configure access to any other database.
Check that the Dashboard Server application pool account has the db_datareader role on the database that is being queried (see How to check and modify the application pool identity). See How to configure access to a database for use with the SQL tile.
It is important to note that the account you are logging into Dashboard Server with has no effect on database access. What is important is the user (identity) of the application pool inside IIS which is being used by Dashboard Server (see How to check and modify the application pool identity).
Check the connection string in the SQL tile configuration.
To query the Data Warehouse the connection string can simply be set to:
To connect to any other database you will need to specify the server and database as described below:
Data Source=<SQLservername>;Initial Catalog=<DatabaseName>;Integrated Security=True;
For more information about connection strings see How to use the SQL tile.
Check that you are using the correct tile type (Grid or Scalar) depending on the results output in SQL Server Management Studio.
The SQL Grid tile should be used for queries that return a table of results.
The SQL Scalar tile should be used when the result of the query is a single number.
Line Graph shows "A value column and a timestamp column are mandatory in the query results, please modify your query"
Both a DateTime field AND a Numeric value field are necessary for a line graph to be drawn. This message indicates that the query results are missing either a DateTime field, a Numeric value field or both.