However, when you use the cfgdbcmd.cmd I was receiving a number of SQL connectivity errors. By default SQL 2005 Express doesn’t allow remote connectivity which is needed by SQLCMD, so you need to follow these instructions from Microsoft to turn this on – http://support.microsoft.com/kb/914277

Once I followed these steps I was still having problems ! So I tried to telnet to my local SQL server on port 1433 and my SQL server wasn’t responding.

In the Event Viewer, I could see that for MSSQL$SQLEXPRESS it informed me that “Server is listening on [ ‘any’ <ipv4> 55558]” I then went into the SQL Server Configuration Manager, Protocols for SQLEXPRESS, TCP/IP and I changed the setting IPAll from 55558 to 1433. After restarting the SQL service I could then perform a telnet localhost 1433 !

Now, when I ran the cfgdbcmd.cmd command, it successfully connected to SQL and changed my default Director database from Apache to SQL Express.