18456 (login failed) needs the
STATE value to know why it failed. Look in the error log. – Sean Gallardy
Are you sure that if you added yourself tot he group that this sql server is connecting to a domain controller that has the updated info? If you have multiple domain servers it may take some time to have that info replicate a across to all servers. – Jeff A
This is the most comprehensive guide I have seen so far:
You need the state first to use that document. – SqlWorldWide
After you created the AD group and added yourself to it, did you logoff/login? AD Group permissions are only enumerated at login (e.g. the Kerberos Access Token). – John Eisbrener
Community Wiki answer compiled from question comments. Community wiki posts have been donated to the community in hopes that others will edit them to keep them up to date, to add useful information, and generally improve their quality.