Article ID: 4354, created on Mar 24, 2008, last review on May 11, 2014

  • Applies to:
  • Sphera

Symptoms

sa user login failure when trying to install SQL server Valueapp.

Resolution

If the SQL user "sa" password was changed, you also need to update the config.ini file under %sphera_home_dir%\plugins\sqlserver.
It may also be that the pswdencrypt utility was run more the once on the config.ini, this is also a potential reason for this error.

Please do the following to fix this issue:
In the config.ini file (under %sphera_home_dir%\plugins\sqlserver), reenter the "sa" user password (not encrypted)

Run this command from command line:
C:\program files\Sphera\ServerDirector\upgradescripts\PswdEncrypt.exe \e C:\program files\Sphera\ServerDirector\plugins\sqlserver\config.ini

(run this command only once to encrypt the password).

5f478287f7e74fe9b07217d8131cd741 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF