ASA Database Administration Guide
  Working with Database Files
    Using the utility database

Connecting to the utility database

You can start the utility database on a database server by specifying utility_db as the database name when connecting to the server. The user ID and password requirements are different for the personal server and the network server.

For the personal database server, there are no security restrictions for connecting to the utility database. It is assumed that anybody who can connect to the personal database server can access the file system directly, and so no attempt is made to screen users based on passwords.

For more information, see Utility database passwords.

To connect to the utility database on the personal server (Interactive SQL)

1. Start a database server with the following command:

   dbeng9.exe -n TestEng

2. Start Interactive SQL.

3. In the Connect dialog, enter DBA as the user ID, and enter any non-blank password. The password itself is not checked, but it must be non-empty.

4. On the Database tab, enter utility_db as the database name.

5. Click OK to connect.

   Interactive SQL connects to the utility database on the personal server named TestEng, without loading a real database.

For the network server, there are security restrictions on connections. A password is held in the file util_db.ini in the same directory as the database server executable.

To connect to the utility database on the network server (Interactive SQL)

1. Add a password to the file util_db.ini in the same directory as the database server executable. For example, the following util_db.ini file has the password ASA.

   [UTILITY_DB]
   PWD=ASA

2. Start a database server with the following command:

   dbsrv9.exe -n TestEng

3. Start Interactive SQL.

4. In the Connect dialog, enter DBA as the user ID, and enter the password held in the file util_db.ini.

5. On the Database tab, enter utility_db as the database name.

6. Click OK to connect.

   Interactive SQL connects to the utility database on the network server named TestEng, without loading a real database.

For more information, see Connecting to a Database.