I want to add an AD security group to my MS SQL 2005, which will contain the personal allowed to fully manage all aspects of the server.
I have created the group (DOMAIN\SQL Admins) and added it to the Security -> Logins list, on the server. Yet, a user, member of that group, can't connected. It gets:
Error number 18456, Severity 14, State 1
I have granted everything available on the Logins list. I have added the domain group to the local Administrators group on the server. No dice. If I add the user to the Logins list specifically (DOMAIN\user), it works.
Could anyone shed some light? I will update the questions if more information is needed.