Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Network Performance Monitor (NPM) > The current user has not been assigned a valid default database. Use SQL Server Management Tools to create a new database, and then assign it as the default database for the current user

The current user has not been assigned a valid default database. Use SQL Server Management Tools to create a new database, and then assign it as the default database for the current user

Created by Malik Haider, last modified by MindTouch on Jun 23, 2016

Views: 1,190 Votes: 1 Revisions: 5

Overview

This article addresses the following error that appears when entering the new SQL server information after migrating a user and the database to a new SQL server or after deleting the database assigned to the user:

The current user has not been assigned a valid default database. Use SQL Server Management Tools to create a new database, and then assign it as the default database for the current user.

Environment

All Orion Core versions

Resolution

  1. Use a SQL Server Management tool such as SQL Server Management Studio Express to connect to your SQL server as an administrator and verify the following settings:
  2. The Default database field is set to your Orion database.
  3. Your NetPerfMon database is selected in the Users mapped to this login list.
  4. The Public and db_owner options are selected under Database role membership.

 

Last modified

Tags

Classifications

Public