SQL Server

Question

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!

Answer 1

Hi Fernando Gutierrez,

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!

Answer 2

Hi,

You may create user through SSMS as you mentioned & secondly through Transact SQL. Please go through below link for instructions:

https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-login?view=sql-server-ver16

https://www.mssqltips.com/sqlservertip/7447/sql-server-database-security-logins-users/