Submit a ticketCall us

WebinarUpcoming Webinar: Should I Move My Database to the Cloud?

So you’ve been running an on-premises SQL Server® for a while now. Maybe you’ve moved it from bare metal to a VM, and have seen some positive benefits. But, do you want to see more? If you said “YES!”, then this session is for you, as James Serra will review the many benefits that can be gained by moving your on-prem SQL Server to an Azure® VM (IaaS). He’ll also talk about the many hybrid approaches, so you can gradually move to the cloud. If you are interested in cost savings, additional features, ease of use, quick scaling, improved reliability, and ending the days of upgrading hardware, this is the session for you.

Register now.

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: 819 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

Tags

Classifications

Public