That’s the default behavior when creating logins in Azure SQL Server. If you’re looking for a GUI to create users and logins, Azure SQL doesn’t support that at this moment.
Thank You!
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello
I would like someone to help me with the following problem I am having.
From SQL Management Studio. In SQL Server, when I have to create a new Login, when I right-click on the Login folder and select new login, by default it opens the way to create that log with Script type and I would need it to be done manually, to enter the name of the Login, the roles and the databases to access.
Where can I change the way to create new Logins.
Thanks!
That’s the default behavior when creating logins in Azure SQL Server. If you’re looking for a GUI to create users and logins, Azure SQL doesn’t support that at this moment.
Thank You!
Hi,
You may create user through SSMS as you mentioned & secondly through Transact SQL. Please go through below link for instructions:
https://www.mssqltips.com/sqlservertip/7447/sql-server-database-security-logins-users/