How do I move the database used by Secure Password Administrator to a new computer? (NETIQKB54006)

  • Document ID:7754006
  • Creation Date:02-Feb-2007
  • Modified Date:05-Oct-2011
    • Micro Focus Products:
      Secure Password Administrator

Environment

Secure Password Administrator 1.0

Situation

How do I move the database used by Secure Password Administrator to a new computer?

What files must be changed if I migrate the database?

Resolution

Secure Password Administrator (SPA) references a file for the location of the Microsoft SQL Server database. If the location of the database changes, the file needs to be updated to point to the correct path of the new SQL database and server.  By default, the file is located in c:\Program Files\NetIQ\SPA\Config\pool.properties. 

To change this path, edit the vigilent.url path in the pool.properties file to point to the new location of the Microsoft SQL Server database.  Once changed, restart the NetIQ Secure Password Administrator Service.

If the password for the SPAService account has changed, or needs to be changed in SQL, it will be necessary to run the DatabaseCredentials.bat file located in c:\Program Files\NetIQ\SPA\bin.  DatabaseCredentials.bat will synchronize the password for the SPAService login in SQL to the credentials that SPA is using to access SQL in an encrypted file located on the SPA server.  After running DatabaseCredentials.bat, the NetIQ Secure Password Administrator service should be restarted.

Here are the steps to perform to re-configure SPA after the existing SPA database has been moved to a new SQL server:

 

  1. Create a new login account on the target SQL server for use by SPA.  Create a login account named "SPAService" using Enterprise Manager.  Make note of the password for this new account.  Also make sure that it is given ?Permit? access to the SPA database.
  2. On the machine where SPA is installed, map to c:\Program Files\NetIQ\SPA\config.  Edit the pool.properties file with Notepad and change the location of the vigilant.url path to point to the new location for the SQL database. Save the changes.
  3. Update the password for the SPAService account used by SPA.  Map to c:\Program Files\NetIQ\SPA\bin directory in Windows Explorer and double-click the DatabaseCredentials.bat file.  Enter the password for the new SPAService account you created in step 1) above.  Click Apply and OK to exit.
  4. Finally, restart the NetIQ Secure Password Administrator Service.

Additional Information

Formerly known as NETIQKB54006