Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
phillips_da
Starting Member
1 Post |
 Posted - 2006-09-01 : 09:40:21
|
| Please excuse me if this is basic SQL, however I'm new to SQL and how it works. I'm running SQL Server 2005 and have a number of databases. What I want to do is control access to each database via an Active Directory group. The group has been setup in AD and users added. I've then gone into SQL Management Studio and gone to the Security folder under the server and then Logins and added the group. Within that I've then added permissions to a specific database. All good so far, however when you try to login to the database I get a Login failed error message. In contrast if I add individual users to the security, Logins on SQL Manager I can get the DB to open with a username and password box for the specific user. What I would like to know is: How can I control access to SQL Databases using Active Directory Security Groups? What setup is required on the SQL side to allow access to the databases from users in the security groups, but still require them to login with their windows authentication? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-04 : 06:08:27
|
| You also have to set default permission for the group, such as DATAREADER per database allowed.Also set default database per group.Then go to this page http://www.carlprothman.net/Default.aspx?tabid=81 and check out SSPI (trusted connection) and SQL SERVER, such asoConn.Open "Provider=sqloledb;" & _ "Data Source=myServerName;" & _ "Initial Catalog=myDatabaseName;" & _ "Integrated Security=SSPI"Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
SQL Server 2005 AD Groups