If you login to your Director Server and select Manage – IBM Systems Director Server you should see that Apache is the current database.

To migrate to a remote instance of Microsoft SQL Server 2005, follow these instructions:

1) Ensure that the pre-requisite software is installed on the ISD server:

Microsoft SQL Server JDBC Driver 3.0

Microsoft SQL Server Native Client

Microsoft SQL Server 2005 Command Line Query Utility

You can download these components from Microsoft’s web sites. I’ve stored the versions I used here. I found I had to logoff/logon again so the SQL command line tool would be found in the steps below.

2) Stop the IBM Systems Director Service.

3) On your SQL server, create a database for Director, for example IBMSystemsDirectorDB and an associated owner account. I called mine SystemsDirectorDBUser

Note that I’ve unticked the enforce password policy and expiration.

4) Edit the following file C:\Program Files\IBM\Director\proddata\cfgdbcmd.rsp and comment out the Apache section and update the SQL database section. I’ve attached a copy of my cfgdbcmd.rsp file here. The password isn’t shown in my file (put in your own) and this is encrypted in the next step anyhow.

5) Encrypt the password in the cfgdbcmd.rsp via the following command: C:\Program Files\IBM\Director\bin cfgserver.bat –db