SQLTeam.com | Weblogs | Forums

Trusted connection from AD Universal Distribution group


I have many users joined to an AD Universal Distribution group. I setup a Windows logon to my database via Windows Authentication but logon permission is denied.

Using exactly the same config from a Global Security AD group, logon is successful for all users.

Can Universal Distribution groups be used in a Windows trusted connection to MS SQL? And if not is there an easy workaround, without having to create a Global Security Group. and map my users again?

many thanks


Not as far as I know - the distribution group cannot be used for authentication purposes. The workaround is to use a global email-enabled security group.