SQL Server Management Studio Logins Dialog missing

Question

I am running SQL Server Management Studio v17.6.

The online tutorials for creating a new Login show a dialog that comes up when your right-click on Logins and select New Login.

I don't see this dialog; instead I get a script to CREATE LOGIN which is OK but I would prefer the dialog.

I don't see an option to switch from getting a script to getting the dialog. I don't know if this version does not have the dialog or if I am just not finding the option.

Answer 1

Currently this is an Azure SQL limitation.

More information can be found here on azure.microsoft.com or here on Microsoft docs.

When creating a new login with the following SSMS menu item:

this is what appears with an Azure SQL database:

instead a dialog window appears when using a local database:

Answer 2

I also found a helpful post that explains the limitations at the time of this post.

Azure SQL limitations

What I did was inside SSMS, while connected to your Azure SQL instance, make sure you are first connected to the master database as shown:

Then run this script with your values against the master DB.

CREATE LOGIN WorldCitiesLogin WITH PASSWORD = N'<your_password>' GO

Next, switch your instance in SSMS to the database you want to map your login:

Then, run this script with your user name that maps to the newly created login above:

CREATE USER WorldCitiesUser FOR LOGIN WorldCitiesLogin WITH DEFAULT_SCHEMA = [dbo] GO