SQL Server

Fernando Gutierrez 160 Reputation points
2024-08-22T14:24:50.5566667+00:00

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!

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,670 questions
0 comments
Accepted answer
  1. RahulRandive 9,506 Reputation points
    2024-08-22T14:40:55.9266667+00:00

    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!

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Zahid Butt 956 Reputation points
    2024-08-22T14:34:39.55+00:00
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.