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
You may need to configure access if you wish to use the SQL plugin to query a database other than the data warehouse. The connection to the data warehouse is configured just after installation, so these permissions are probably already in place. See Configuring the data warehouse connection
Configuring access to the OperationsManager (or other) database
For queries on other databases, such as the OperationsManager database, or indeed any other database, the Squared Up application pool account needs to be given the 'apm_datareader', 'db_datareader' roles on the database, as described below:
1. First identify the user account that needs to be given permission.
Squared Up uses the Application Pool Identity account to retrieve data, NOT the account with which you log on to Squared Up. By default the application pool identity is set to NetworkService, but you may have have changed this. See Checking and modifying the application pool identity and make a note of the application pool identity account for use in the next steps:
- If the application pool identity is running as a custom account then add the relevant roles for this custom account.
- If the application pool is set to NETWORK SERVICE and Squared Up is installed on the same server as the database you are accessing then add the relevant role for the NT AUTHORITY\NETWORK SERVICE account.
- If the application pool is set to NETWORK SERVICE and Squared Up is NOT installed on the same server as the database you are accessing then add the relevant role for the Squared Up server's AD computer account (for example, mydomain\mywebserver$)
2. Open SQL Server Management Studio.
3. Expand Security and then Logins. Look for a login with the same name as the Application Pool Identity, as noted above, if one doesn't exist you will need to create one.
4. Right click on the relevant account (as described above) and select Properties.
5. Click on User Mapping.
6. Tick the database you wish to give access to, for example OperationsManager, under 'Users mapped to this login'.
7. In the bottom panel tick 'apm_datareader', 'db_datareader'.
8. Click OK.
For more information about the SQL plugin configuration such as checking that the Connection String is correct see How to configure the SQL plugin
If you still experience problems please send your Squared Up log file (c:\inetpub\wwwroot\SquaredUpv2\Log\rolling.log), a screenshot of the SQL plugin configuration and a copy of the SQL query text and to firstname.lastname@example.org