Adding Windows Group Login

Mikhail Firsov 1,876 Reputation points
2021-05-20T12:22:42.287+00:00

Hello!

Problem with the SQL Server installed on a standalone server:
since I needed to create a new Windows login (Windows group login) I first added a a new group in Computer Management (SQLusers, - TestGROUP I added later)...
98311-00.png

...and tried to select 1) this group (SQLusers) or 2) another group (TestGROUP ) in SSMS:

98295-01.png

  • there were no such groups in the Login\Select users or groups window...(but there was a USER account Test I created earlier!). I used to work with domain group logins and never had any issues with adding domain group logins - why this list of available group/user accounts does not include the groups I had created?

There was no problem with creating this login using TSQL:
98284-02.png

Q2: The Login\Select users or groups list contains only a subset of all user and group accounts available on the server (you can compare them on the first and second screenshots) - does anybody know based on what SQL is filtering this list?

Thank you in advance,
Michael

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,750 questions
0 comments
Accepted answer
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-05-21T02:31:51.027+00:00

    Hi @MikhaiFirsov-1277,

    why this list of available group/user accounts does not include the groups I had created?

    This is because the group are not selected in the object types.
    We can go to “Select User or Group” dialog box, under Select this object type, click Object Types... to open the Object Types dialog box and select Group, and click Advanced and find Now.
    98407-01.jpg

    Then we will see all windows groups show in the Search Results:
    98395-02.jpg
    Please refer to this doc which might help.

    does anybody know based on what SQL is filtering this list?

    The Login\Select users or groups list is related to Windows as Erland mentioned.

    Best Regards,
    Amelia

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 101.2K Reputation points MVP
    2021-05-20T22:14:46.887+00:00

    SQL is not filtering anything. SQL does not even see the list. Isn't that a standard Windows dialog that SSMS uses?

    0 comments
  2. Mikhail Firsov 1,876 Reputation points
    2021-05-21T07:50:01.283+00:00

    Oh, sorry - I also thought the SQL just opens an ordinary Select users list (as ErlandSommarskog) said, but I asked that question after comparing this list from a folder's Security tab with the SQL's Select users list - they were different. I just didn't realise the default scope may be different :(
    98505-q21.png

    Sorry for the question once again.

    Regards,
    Michael

    0 comments