Adding users to AzureSQL Databases using SSMS

Chris Kellum 1 Reputation point
2021-08-18T17:08:36.26+00:00

I am trying to add users to an AzureSQL Database using SSMS 18.9.

When right clicking the User tab and choosing New Users, the SQL Editor opens, not the Popup Wizard I am familiar with.

In AzureSQL is there a new Wizard or other method for adding users similar to the Popup Wizard in SSMS?

From what I have been able to find, the pop up wizards are all disabled when connected to an AzureSQL Database.

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Anurag Sharma 17,576 Reputation points
    2021-08-19T06:33:40.517+00:00

    Hi @Chris Kellum , welcome to Microsoft Q&A forum.

    The pop up wizard to add users and other objects is disabled through SSMS for Azure SQL Database as rightly mentioned by you. Even through Azure Data Studio, we need to use the transact sql to create SQL objects. Sorry for the inconvenience caused. However, adding the users through TSQL is as simple and easy as through wizard. Below is one document that thoroughly explains the same like creating login, creating users etc.

    Create and Manage logins

    124546-image.png

    If you are looking for any specific object creation, we can work to provide proper scripts as needed.

    Please let us know if this helps or we can discuss further.

    ----------

    If answer helps, please mark it 'Accept Answer'

    0 comments No comments