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 |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2011-10-18 : 10:44:52
|
| Hi everyone,This is for 2008 R2.I installed 2008 R2 64 bit onto a Windows 2003 server.I chose Windows authentication. It seems that users that are in the local Administrators group are NOT automatically able to access SQL Server. But, if I remember correctly, with Mixed Mode authentication, anyone added to the Administrators group has the sysadmin role by default. Is this correct?Thanks, John |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-10-18 : 11:08:07
|
| That was true SQL 2005 SP1 and earlier. In 2005 SP2 the security was tightened so that local admin != sysadmin. Now if you want someone to be admin, you have to specify it, it doesn't happen by default, which is a very good thing for security.--Gail ShawSQL Server MVP |
 |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2011-10-18 : 16:06:18
|
| Thanks, GilaMonster. I agree, a long-needed enhancement. |
|
|
|
|
|
|
2008 Security