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