Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

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

Tags

Classifications

Public