The SquaredUp web application runs using an ASP.NET application pool process. This process can be configured to run as a specific user, which is called the application pool identity.
SquaredUp uses the end user's identity when showing data from Azure Monitor, but the application pool identity is used for the following important tasks:
- Accessing local files (e.g. log file, configuration files) on the web server
- Connecting to SQL and other WebAPI data sources
By default, the application pool is configured to use the NetworkService identity, which appears as the computer account when accessing network resources.
If you have deployed SquaredUp within an Active Directory domain, you may want to change the application pool identity to an Active Directory user account created specifically for SquaredUp. This is called a domain service account.
If you change the application pool identity after installation, you must follow the instructions below.
You can specify a different application pool identity for a new installation using the modify option on the Ready to Deploy page of a new SquaredUp installation. This sets up the correct file permissions automatically.
Viewing the application pool identity
1. Confirm the name of the SquaredUp application pool
- In IIS expand Default Web Site and right-click on the SquaredUp website.
- Go to Manage Application > Advanced Settings.
- Check that the Application Pool is SquaredUpv4.
2. View the application pool identity
You can check the application pool identity by using IIS:
- In IIS, click on Application Pools.
- Right-click on SquaredUpv4 and select Advanced Settings.
- Under Process Model, you will see Identity. By default this is set to NetworkService, but if you wish to change the application pool identity you can change it here.
The SquaredUp application pool identity you see here is often referred to as the SquaredUpAccount in SquaredUp articles.
Modifying the application pool identity
1. Enter the account credentials
Follow the steps above to check and modify the account used by the application pool.
2. Configure the file permissions on the SquaredUp server
The account you are logging into SquaredUp with has no effect on disk read/write permissions. What is important is the identity (user account) of the IIS application pool used by SquaredUp.
- Open a command prompt as an administrator (from Start > Run type command prompt, right-click on the Command Prompt icon and click Run as administrator).
- Type: cd C:\inetpub\wwwroot\SquaredUpv4
- Type: squaredup4 permissions --user="DOMAIN\USER" Where DOMAIN is your domain and USER is the SquaredUp application pool identity. For example, if the application pool identity has been changed to a user called svc-squaredup in the domain sales you would type: squaredup4 permissions --user="sales\svc-squaredup" If your SquaredUp application pool identity is NetworkService and you need to re-apply the correct permissions for NetworkService then type: squaredup4 permissions --user="networkservice"
3. Configure any other required SQL or Web API data sources
If you are using SQL Tiles or WebAPI Tiles on your dashboards, and these connections require Windows Authentication, remember to update the SQL or WebAPI data sources to provide the new application pool identity with the required permissions.
How to configure access to a database for use with the SQL tile