Moving Sharepoint config database location
http://sharepointsherpa.com/2008/04/18/sharepoint-2007-move-content-and-configuration-databases/
The SharePoint Sherpa blog has the outline of how to run this task;
**** BACKUP FIRST AND PRACTICE THIS IN A TEST ENVIRONMENT ****
stsadm -o deleteconfigdb
stsadm –o setconfigdb -connect –databaseserver target_SQL_server -databasename databasename -farmuser your_farm_account -farmpassword your_farm_password
But….. this didn’t work for me. I then fixed the firewall on SQL Server 2008 R2 and it worked. Yay
