Adding Windows Group Login

Question

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)...

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

• 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:

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

Answer 1

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.

Then we will see all windows groups show in the Search Results:

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.

Answer 2

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

Answer 3

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 :(

Sorry for the question once again.

Regards,
Michael