IBM Tivoli Provisioning Manager for Images, Version 7.1.1.14

Password protecting a Microsoft Access database

If your product configuration is based on a Microsoft Access database, you can optionally choose to password protect the database.

About this task

The default Microsoft Access database is not password protected because it is intended to be used for evaluation purposes only. If you want to password protect your database, perform the following steps:

Procedure

Stop the OS deployment server.
Set the password for the Microsoft Access database. The Microsoft Access database is located by default in the path C:\Program Files\IBM\TPMfI\AutoDeploy.mdb.
1. Create a visual basic script named, chgpwd.vbs, to set the password and copy the sample script specified in Sample chgpwd.vbs script to the chgpwd.vbs file. Ensure you customize dbSource, newPassword, and oldPassword according to your environment.
2. Run the script.
Edit the radb.ini file located in the path C:\TPMfOS Files\global\rad\radb.ini with the new password to be used by the server. Create this file in the path if it does not already exist as follows:
```
[Settings]
ODBC_Source=AutoDeploy
ODBC_Username=admin
ODBC_Password=<new_password> 
```
Start the OS deployment server.

Sample chgpwd.vbs script

file chgpwd.vbs  (customize dbSource, newPassword, oldPassword): 
dbSource ="C:\Program Files\IBM\TPMfI\AutoDeploy.mdb"
'use back-quotes `` for empty password
newPassword ="<new_password>"
oldPassword ="``"
set conn = CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbSource & ";
  Persist Security Info=False;Mode=12;Jet OLEDB:Database Password=" & oldPassword
conn.Execute "ALTER Database Password " & newPassword & " " & oldPassword & ";"
conn.close

Feedback