Cannot Click Next on Database Settings Configuration Wizard

10/28/2020 12:58 PM

12/21/2021 3:55 AM

Always investigate logs to obtain information on the cause of failure. Configuration Wizard logs are located here
C:\ProgramData\SolarWinds\Logs\Orion\ConfigurationWizard.log

If the user receives an error similar to the following, please proceed with this article.
VIEW SERVER STATE permission was denied on object ‘server’, database 'master'.
The user does not have permission to perform this action.


 

Orion Platform

SolarWindsOrionDatabaseUser (or database user that is used with Orion DB) needs sufficient access to the database.

Resolution 1:
From the SQL Server Management Studio:

1. Connect to the SQL instance
2. Navigate to Security > Logins
3. Right-click the [SolarWindsOrionDatabaseUser] Account > Select Properties
4. Select the Securables page
5. In the bottom pane, scroll to the bottom and Grant: View Server State

Alternative - SQL command to grant permission.

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.
GRANT VIEW SERVER STATE TO <user>

Resolution 2:
Add sysadmin role to the service account used to connect the Solarwinds application to the Solarwinds database. 
Using SQL Script:

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

EXEC master..sp_addsrvrolemember @loginame = N'test', @rolename = N'sysadmin'
GO

Please see more details here:
Database permission error in the Configuration Wizard for Orion Platform products