Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Network Configuration Manager (NCM) > The SQL user account password is not valid

The SQL user account password is not valid

Updated August 1, 2016

Overview

You have an issue when trying to run the Orion Configuration Wizard using SQL account and it failed with the error:

The SQL user account password is not valid 

 

 

 

 

Log in to the SQL Server with your Windows account. Confirm that the user account and password is correct and have no issues at all using your Windows Authentication to SQL server.

 

 

 

 

Using the same account with SQL Management Studio, there is the same issue and any of the SQL users fail to log in. 

 

You have also confirmed that the SQL server have both mixed mode authentication so both the SQL and Windows users can log in. However, the issue persists when any of the SQL servers is trying to log in.

 

 

 

Any local SQL user fails to log in. 

Environment

All NCM versions

Resolution

You will need to restart your SQL Server according to the MSDN link on Changing server authentication mode 

(© 2016 <Microsoft>, available at <www.microsoft.com>, obtained on <August 1, 2016.)

  1. To change security authentication mode:
  2. In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
  3. On the Security page, under Server authentication, select the new server authentication mode, and then click OK.
  4. In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.
  5. To restart SQL Server from SQL Server Management Studio:
    In Object Explorer, right-click your server, and then click Restart. If SQL Server Agent is running, it must also be restarted.
  6. Restart SQL Server and then try to log in again will resolve this issue.

 

There is another article on Choosing an authentication mode (© 2016 <Microsoft>, available at www.microsoft.com, obtained on August 1, 2016). See user comments at the bottom, referencing a registry key that you can look at. It also says you will need to restart the service once you have changed it.

See also the The SQL user account password is not valid article for related Orion platform issues. 

 

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.

 

Last modified
22:04, 26 Mar 2017

Tags

Classifications

Public