eSight System Becomes Faulty After the SQLServer User Password Is Changed Using a Database Tool

Question

After I use a database tool instead the maintenance tool to change the password for an NMS user or administrators of the eSight database, some problems occur on the eSight system. For example, I cannot start the eSight using the maintenance tool. How do I resolve the problems?

Answer

The maintenance tool of the eSight system changes the database access password and the database password. Other database tools, however, change only the database password. Use the maintenance tool instead of a database tool to change the password for an NMS user or administrators of the database. Otherwise, the following problems may occur:

• The eSight system cannot be started using the maintenance tool if the password for a database NMS user is changed.
• The password for a database NMS user cannot be changed using the maintenance tool if the password for the administrator is changed.

When these problems occur, perform the following steps to change the password used for database access to maintain password consistency:

1. On the maintenance tool, choose System > DB Password Management from the main menu.
2. Change the database access password to the same as the database password.
   • For the eSight system startup failure

     On the Database NMS User password area of the DB Password Management window, set parameters listed in Table 11-3 in the displayed window.

   Table 11-3 Parameters required for changing the password for a database NMS use

   Parameter	Description
   Old Password	Enter the NMS user password used for database access.
   New Password	Enter the database NMS user password changed using the database tool.
   Confirm Password	Enter the new password again for confirmation.

   • For the failure to change the password for a database NMS user using the maintenance tool

     On the Database System Administrator password area of the DB Password Management window, set parameters listed in Table 11-4 in the displayed window.

   Table 11-4 Parameters required for changing the password for an administrator

   Parameter	Description
   Old Password	Enter the administrator password used for database access.
   New Password	Enter the administrator password changed using the database tool.
   Confirm Password	Enter the new password again for confirmation.

3. Click Apply.
4. For the eSight startup failure, start the eSight again. For the failure to change the password for a common user using the maintenance tool, change the password for the database NMS user again.