question

ChrisKellum-0227 avatar image
0 Votes"
ChrisKellum-0227 asked AnuragSharma-MSFT commented

Adding users to AzureSQL Databases using SSMS

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
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ChrisKellum-0227, just wanted to follow up if you need more details on the same.

0 Votes 0 ·

1 Answer

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered AnuragSharma-MSFT edited

Hi @ChrisKellum-0227, 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'



image.png (14.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.