Access Granted or Not? Question of the Day

Access Granted or Not? is my latest Question Of The Day and I think it represents a pretty good troubleshooting scenario, a user can connect to one database but not another using the same Windows credentials. It’s one of those questions generated from a learning moment of my own, I had to figure out the problem myself, and then turned it into a question to share the knowledge. Go give it a try!