Submit a ticketCall us

Putting Your Logs Where They Belong with the New SolarWinds Log Manager for Orion

The new SolarWinds® Log Manager for Orion® finally puts your log data right where it belongs, in the heart of your Orion console. Gain insight into the performance of your infrastructure by monitoring your logs in a unified console allowing you to see a wealth of information about the health and performance of your network and servers.

Reserve a Seat for Wednesday May 23rd 11am CDT | Reserve a Seat for Tuesday May 22nd 10:30am GMT | Reserve a Seat for Tuesday May 22nd 1pm SGT / 3pm AEST

Home > Success Center > Network Performance Monitor (NPM) > System.Data.SqlClient.SqlException (0x80131904): Login failed for user SolarWindsOrionDatabaseUser

System.Data.SqlClient.SqlException (0x80131904): Login failed for user SolarWindsOrionDatabaseUser

Created by Michael Perez, last modified by Alexander Aguilar on Feb 24, 2017

Views: 6,673 Votes: 2 Revisions: 7

Overview

Configuration Wizard fails and is showing the following error in the ConfigurationWizard.log:

System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'SolarWindsOrionDatabaseUser'

This issue usually happens when the account or password that Orion uses to contact to the database was changed during an upgrade, or new product installation.

Environment

All Orion products

Cause 

The Configuration Wizard is using the previous connection string to access the Orion database.  During additional installations or product upgrades, the option to change the username or password is no longer presented during the Configuration Wizard.  

Resolution

  1. Open regedit.exe
  2. Create a backup of the registry before making any changes - Importing or exporting Keys.
  3. Go to one of the following keys:

    On a 64 bit OS:  

    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SolarWinds.net\ConfigurationWizard\ConfiguredModules   

    On a 32 bit OS:  

    HKEY_LOCAL_MACHINE\SOFTWARE\SolarWinds.net\ConfigurationWizard\ConfiguredModules

  4. Delete all keys except for (Default).
  5. Run the Configuration Wizard again (Start > All Programs > SolarWinds Orion > Configuration and Auto-Discovery).
  6. Select Database, Website, and Services and click Next.
  7. Enter the correct credentials for the Orion database user and click Next.
  8. Select the Orion database and click Next.
  9. Enter the correct credentials for the Orion database and complete the remaining steps in the Configuration Wizard.

Note: If the above fails to resolve the issue make sure Named Pipes is enabled for the SQL server.

 

Last modified

Tags

Classifications

Public