Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Network Performance Monitor (NPM) > SolarWinds database in Single User mode

SolarWinds database in Single User mode

Created by Matthew Lamb, last modified by MindTouch on Jun 23, 2016

Views: 7 Votes: 0 Revisions: 5

Overview

This article addresses the issue where the SolarWinds Orion database is incorrectly placed into a Single User mode state.

Environment

  • All Orion Core versions
  • Microsoft SQL Server

Cause 

This can occur when the database was set in Single User mode by the DBA or forced by the SQL server due to an issue. However, Orion requires it be in a Multi-user mode to allow multiple connections and updates for all the necessary services and servers.

Resolution

  1. Restart the Microsoft SQL server. 
    Note: This step is needed to clear out whichever user or connection currently has control of the database currently. It is possible to log in as an SA and query all current processes running on that database and kill them, but a reboot of the server will ensure the connection is cut every time, regardless of SQL permissions.
  2. Open SQL Management Studio on the SQL server.
  3. Select the database and click New Query.
  4. Run the following query in the query screen:
    Alter database [Current] SET Multi_USER
  5. Verify that the database is no longer in Single User mode.
 

 

Last modified
23:35, 22 Jun 2016

Tags

Classifications

Public