Well, At first, I thought that we may have to reconfigure the biztalk server or apply the SSO master secret from the backup. But to my Surprise, BizTalk is running as normal after changing the SQL services user to domain user.
Things to be noted here are
1. BizTalk still uses the same local user to connect to the database.
2. Only the SQL services run under different domain user now.