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 |
|
mc_tiger
Starting Member
2 Posts |
 Posted - 2009-04-20 : 16:09:11
|
| I have created a windows security group in AD and added myself as a user to this group. I then added this group to sql 2008 and made this the owner of a DB. However, when I try to login to sql server as that user I get access denied. Not sure if I am missing something to get Windows groups to work. Thanks, |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-20 : 16:42:10
|
Did you logout and login again from your AD?What is your authentication mode in SQL Server?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
mc_tiger
Starting Member
2 Posts |
Posted - 2009-04-20 : 16:49:16
|
| Yes i logged out and logged back in.The authentication mode is Windows Authentication Mode. |
|
|
|
|
|
|
sql server 2008 adding windows group