Hello,
These articles are great as they solved my issues..
But as a local administrator I was not able to see any databases in SQL Enterprise Manager having a login failed for any account I was using.
Only a Domain Administrator was able to access it and let me correct the issue... which permissions was missing for me to be able to do the same correction on SQL without being a domain administrator?
I am dbo on several databases and also sysadmin role on them.
Should I be dbo on master? will it be enough?
Thank you,
Dominique