question

MikhailFirsov-1277 avatar image
0 Votes"
MikhailFirsov-1277 asked MikhailFirsov-1277 answered

Adding Windows Group Login

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-general
00.png (94.1 KiB)
01.png (107.2 KiB)
02.png (88.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

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.



01.jpg (32.2 KiB)
02.jpg (53.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MikhailFirsov-1277 avatar image
0 Votes"
MikhailFirsov-1277 answered

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


q21.png (58.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.