<div>
<div class="content wysiwyg-content">
Hey<br />
<br />
I have created a AD security group - added some users.<br />
The AD group is added to the SQL servers sysadm role, but the users are unable to open det management console.<br />
<br />
If I add the users directly to the SQL sysadm role it works.. Why does the AD group not work?<br />
<br />
Why?<br />
<br />
Mike
</div>
</div>


Hey

I have created a AD security group - added some users.
The AD group is added to the SQL servers sysadm role, but the users are unable to open det management console.

If I add the users directly to the SQL sysadm role it works.. Why does the AD group not work?

Why?

Mike

AD sec. group and SQL 2008 R2 SP1?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.