You try to login to SQL Server and you get a really nasty message: The key data in the error message At first glance, it appears to be utterly useless. The only useful message seems to be “Login failed for user 'myuser'.” but what we really need to know is “why?”. That information is somewhat … Continue reading SQL Server – Login failed for user ‘[username]’ – How to troubleshoot?
Permissions are complex! Permissions management is not easy. You have a lot to deal with Direct user privileges via grants Privileges to AD Group login of which user is part of User could be part of multiple AD groups which have a login on the instance Privileges granted to the role that user is in … Continue reading SQL Server – Find Effective Permissions of An User At Database, Server or Object Level – The Right Way!
I cannot imagine a life without PowerShell now. You would agreee after you find out why. This is what I had to do today. The very real problem: I have a list of about 30 servers. I need to add an AD group name to the local adminstrators group on all 30 servers Create a … Continue reading Using PowerShell – Add user or group to local Administrators group in Windows + Create SQL Server Login