Network Management

Unable to view server state of the SQL server in Orion platform

When running the diagnostic tool on the Orion server you can get an error that the tool was not able to verify the max degree of parallelism due to insufficient SQL permissions on the Orion database user account. Or when running the Configuration Wizard, it does not proceed past selecting a database.

First published date

11/1/2019 2:53 PM

Last published date

3/9/2023 2:48 PM

Overview

When running the Configuration Wizard, you select a database but cannot proceed past the page to select a database. The ConfigurationWizard.log (C:\ProgramData\SolarWinds\Logs\Orion) file will have an error such as:

ERROR SceneContainer - SceneContainer:bntNext_Click: System.Data.SqlClient.SqlException (0x80131904): 
VIEW SERVER STATE permission was denied on object 'server', database 'master'.
The user does not have permission to perform this action.

Product section

Network Performance Monitor

Cause

The Orion Database User Account does not have permission to view the server state on the SQL server. This permission is required to proceed.

Resolution

Grant View Server State permission to the Orion Database User Account.

Steps to modify the account permission on the SQL database:

1. Connect to the database using SQL Server Management Studio

2. Navigate to the user accounts. Security>Logins>Locate the account used to manage the Orion database

3. Right-click the account and choose Properties.

4. Select the Securables page

5. In the bottom pane, scroll to the bottom and Grant - View Server State

The error should no longer be present when you run the diagnostic tool.

-- 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 [SQL Server Login/Configuration Wizard Username]

NOTE: if the user logged in does not have the necessary permission to grant view server state to this user, the action will not grant permission and no error message will be shown. However, if you use the query, an error will be returned. In that situation, you must connect to the database server using an account that has sysadmin permissions.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.