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.