Now you re-deploy.
Assuming you are using JBOSS (instead of Weblogic or Websphere),
This is easily done from the Start Menu under HP ALM Platform / Deploy Wizard.
Follow the defaults and allow it to start JBOSS at the end and you should be good to go.
**A WORD OF WARNING,** though: Try to get yor DBA to re-migrate the qcsiteadmin_db from your OLD SQL-Server to your NEW one (and re-run the td user fix EXEC commands as before). Have him choose the last backup made from just before he disabled the ''td'' user or SQL instance (probably a few days ago).
Since your QC/ALM instance was still pointing to the OLD SQL-Server instance all along, any new users, project changes (like migrating them to a new SQL server instance), etc. are not in the copy on your NEW SQL-server. I hope they did a backup.