Users

This will be no surprise to those who have been working with SQL Server for a long time, but it can be puzzling at first and actually I was a bit confused myself when I stumbled upon this behavior for the first time. SQL Server treats windows users in a special way, a way that could lead us to some interesting observations. First of all, we need a test database and a couple of windows principals to perform our tests: [Read More]

If you are playing with multiple Virtual Machines and multiple SQL Server instances and features, it’s very likely that your virtual machines logon screens are showing all the users you set up for service accounts. In this case, my Master Data Services playground shows the “MDSAppPoolUser” I set up for the MDS web application: Needless to say that I will never need to logon as one of those service accounts and I would be happier if the logon screen just hid them. [Read More]