Contact Support and reference this article.
To grant a user SSMS access to a hosted database, please click 'Create a Case' in the Additional Assistance box on the right and include this solution ID in the case description and the template below.
<<NAME>> - <<SITE ID>> approves to give <<<username>> SSMS access with <<privileges>>> to the PRODUCTION database. The timeframe of when we need this done is <<<DAY>>> between <<<<TIME>>>>. This issue is considered <<<Priority>>>. We have fully discussed these privileges with this user and have accepted this to go into production.