Posts Tagged "Configuration Manager"

SCCM failes to login at SQL database

Posted by on Jan 31, 2011 in SC Configuration Manager, SQL Server | 2 comments

Sometimes it happened to me, that our Microsoft System Center Configuration Manager 2007 R2 (sccmsrv01) failed to login at our dedicated MS SQL 2005 2 nodes cluster (cluster: sqlclu, node 1: sqlclu01 and node 2: sqlclu02). Everything you could find in the sql logs was: Error: 18456, Severity: 14, State: 11. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 192.168.1.10] Since I knew that SCCM wouldn’t try to logon anonymously at the dedicated sql server but with its machine account the error seemed to be related on kerberos and service principal names (SPN). I checked this...

Read More