This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

NPM SP3 install failure

I am receiving a failure message during the Configuration Wizard:

Database configuration failed:

Can not add 'sa' user to database 'NetPerfMon"

See configuration log file for detail.

Anyone have any ideas. I am getting concerned about the stability of this version (9.5).

  • What are the details from the Config. log file?

     

    The configuration log is located - "C:\Program Files\Solarwinds\Orion\ConfigurationWizard.log"

  • It doesn't look like it wrote to it as the config log file is dated almost two months ago. 5/14/09

  • It appears the account you submitted does not have .dbo privileges to write to the DB.

    You can reset the password of the SQL login account used by Orion and then re-run the configuration wizard.

    Open SQL Server Management Studio.

    Expand Security > Logins. Right-Click on your SQL Login and select Properties.

    In the General section change the password and click on ok.

     

    Back to the Orion server. Start > All Programs > SolarWinds Orion > Configuration and Auto-Discovery > Configuration Wizard.

    Select Database and click on Next.

    Ensure you specify the new password during the steps.

     

    If that does not work, you can ask the Configuration Wizard to recreate a new SQL Login and then delete the old one.

    You can also check the logging error in the SQL Server log files. You should have a code detailing why it failed.

    In Management Studio. Expand Management > SQL Server Logs > Current - %Date%

    HTH