Loading...

Create user dialogue not working in SQL Server Management Studio


I'm trying to create some users in SSMS without having to script them manually.

However, when I follow the directions laid out in documentation, I don't get a dialogue. Rather, I get a script-to window, and an SQL template.

Why is SSMS giving me a template here, rather than showing the dialogue/wizard?

- - Source

Answers

answered 6 day ago Andrea #1

You are probably using an Azure SQL Database.

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 on an Azure SQL database:

enter image description here

the following template script is generated:

enter image description here

while the following dialog window appears when using an on premise database:

enter image description here

comments powered by Disqus