Re: Active Directory groups and SQL Server 2008
- From: "Russell Fields" <russellfields@xxxxxxxxxx>
- Date: Wed, 4 Nov 2009 13:41:23 -0500
Dale,
I do this all the time to manage my rights. Scripted from my server and names changed:
USE master
go
CREATE LOGIN [Domain\Server_Database_SpecialRole] FROM WINDOWS
WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]
go
USE Database
go
CREATE USER [Domain\Server_Database_SpecialRole] FOR LOGIN [Domain\Server_Database_SpecialRole]
go
EXEC sp_addrolemember N'SpecialRole', N'Domain\Server_Database_SpecialRole'
go
I don't know if you might be facing some other problem, but that should work fine.
RLF
"BrassicaNigra" <brassica_nigra@xxxxxxxxxxxxxxxx> wrote in message news:7617F251-847C-49A8-B68F-EF51017C73C0@xxxxxxxxxxxxxxxx
Greetings,
We are setting up a new Windows 2008 server with SQL Server 2008 and were
wondering if on the SQL Server side, access can be granted to an Active
Directory group and then anyone who belongs to this group will have the group
level access to the database(s) (without having to create an individual login
for them in SQL).
So far I have not been able to get this to work. If I give each individaul
a SQL login everything works fine, but I would like to just make each user a
member of an AD group and manage access that way.
Am I barking up the wrong tree?
Thanks,
Dale Hoffman
.
- Follow-Ups:
- Using AD Groups as SQL2008 Login
- From: Elijah Baley
- Using AD Groups as SQL2008 Login
- References:
- Active Directory groups and SQL Server 2008
- From: BrassicaNigra
- Active Directory groups and SQL Server 2008
- Prev by Date: Active Directory groups and SQL Server 2008
- Next by Date: SQL Server 2005 - FullText Search
- Previous by thread: Active Directory groups and SQL Server 2008
- Next by thread: Using AD Groups as SQL2008 Login
- Index(es):
Relevant Pages
|
