I’ve never tied to do this. If it’s not a production server, I’d just Unconfigure BizTalk and reconfigure it to use the new SQL. That way all the accounts will be created for you with the correct permissions.
Then you need to reinstall you applications.
You might want to look in the SDK if there is anything on moving to a new SQL. Again, not something I’d even try to do if there was any other way…