1) First take backups of the databases which are in your account.
2) Remove the databases one by one and then disable the MSSQL resource and then again “enable” it. This way you’ll get the new database server i.e. MSSQL 2008.
3) Create the databases again with the same database name, username and password in the account and then restore the databases from backup. This way the database name, username and password remain the same but the database server address will change.
]]>