Following script gives you all user database users, that do not have a server login mapped or where database user name does not match server
Category: Security
Service Principal Names for SQL Server
Service Principal Names (SPN) get used for Kerberos authentication. SQL Server require that all instances have SPNs configured, if not Kerberos authentication fails. By default
Cross-Domain Authentication for SQL Server
How to setup and configure cross domain service principal names.
Windows 2003 Cluster: SQL Node Not able to Join Cluster after Changing MaxTokenSize
As per Cannot Generate SSPI Context article, Link, I had changed the MaxTokenSize to fix the issue. I had read various articles before jumping into
SSPI Context Cannot be generated
I am sure everyone has seen this error there are many articles on MSDN, newsgroups, etc.; but I ran into very interesting problem with these