<div>
Just to clarify, I CAN NOT use an Active Directory group  as a login to SQL Server's Trusted Connection?
</div>


<div>
<div class="content wysiwyg-content">
I have a SQL Server 2005 Database and have granted access to a group from the active directory. Do I need to add per user login, and not a whole group? I ask because, a user in a group gets a login failed message.
</div>
</div>


I have a SQL Server 2005 Database and have granted access to a group from the active directory. Do I need to add per user login, and not a whole group? I ask because, a user in a group gets a login failed message.

Add group to SQL Server 2005 database

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.