question

Wilfred van Dijk avatar image
Wilfred van Dijk asked

not possible to add a group to a database role?

For a Sharepoint 2010 database role, I would like to add an AD group as a role member. However, in SSMS I can olny select users (both SQL and AD) and database roles (when selecting object types). Am I missing something? Is there another way to add an AD group to a databaserole?
securityadministrationsharepoint-2010
6 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·
Have you tried adding the group as a login, then adding to the role?
6 Likes 6 ·
JohnM avatar image JohnM commented ·
@Jonlee Lockwood: +1.
0 Likes 0 ·
Usman Butt avatar image Usman Butt commented ·
@JohnM I guess you forgot to give +1. I guess I did that before you and it still reads 1 :(
0 Likes 0 ·
JohnM avatar image JohnM commented ·
@Usman Butt: My apologies. I think that I failed to do that. Is there a way that I can go back and add points?
0 Likes 0 ·
JohnM avatar image JohnM commented ·
Disregard. I think that I figured it out. Still a newbie around here. =) Sorry for any confusion.
0 Likes 0 ·
Show more comments

1 Answer

·
JohnM avatar image
JohnM answered
The users referenced is referring to the users of the database, not logins on the server. Add the domain group as a login on the sql server and then map the login to the database & corresponding role. Should work just fine!
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Wilfred van Dijk avatar image Wilfred van Dijk commented ·
Yes, this is working!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.