Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

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,317 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