Symptoms
K2 is installing in Azure environment and the K2 database is hosted on SQL azure.
When adding second server to an existing K2 farm, installation couldn't proceed at K2 Database window, an error appears
"The sql server database configuration test failed as user has insufficient privileges: User does not have Security Administration Rights."
Diagnoses
This is a known issue.
Resolution
Please log a support ticket to request the hotfix.