Enabling auto-login with SQL Monitor and IIS
Published 14 February 2023
You can configure SQL Monitor to log in with a single account. This disables SQL Monitor's authentication.
- Open the
appsettings.jsonfile. By default, this is located in%ProgramFiles%\Red Gate\SQL Monitor\Web. Set the
"autoLoginUserName": "admin"in theauthSettingssection. This will automatically log in to theadminaccount. Other valid values areuserandreadonly.Restart the SQL Monitor website.