These links are more for my own reference than anything else to resolve the error: "Cannot generate SSPI context" It is a pesky error message that is related to security setup. All the things you need to check are in the MS article below. How to troubleshoot the "Cannot generate SSPI context" error message In … Continue reading SQL Server – Resolve – Cannot generate SSPI context
I am a strong proponent and a believer of using AD groups (not even AD users) to manage your SQL Server permissions end to end. Restated, you would not have any individual AD users as logins in your SQL Server instance, all instance logins with be AD groups. If you are dealing with plain SQL … Continue reading SQL Server – Drop An User In All Databases & Drop The Login Too!
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!