So, its time for something new. At the first of may 2016, i’am starting as a freelancer. I’m available as IT Architect / Technical Architect, with strong focus on Citrix, Microsoft, VMWare, AirWatch. Overall knowledge of networking & storage. Also available for Consultant/Engineer roles.
SQL Service Principal Name (user as an ‘SQL Server’ Service account) and for example: SCCM 2012
After installing SCCM2012 we find warnings and errors in the SCCM Component Status logs.
Something with SQL, service accounts running as a user, and SPN. Again much info on Microsoft Technet.
Here is How to Configure an SPN for SQL Server Site Database Servers http://technet.microsoft.com/en-us/library/bb735885.aspx or you can grant the permitions to your sql service account so it can configure the SPN itself: Add account permission to create SPN:
Run ADSIEdit as a Domain Admin.
Find the SQL Server, Service account, right click, properties.
Select the Security tab
Click Add. Type “SELF” in the object box. Click OK. (or select SELF if exists)
Select the Properties Tab (NOT Objects)
Scroll down and check the “Allow” box for “Read servicePrincipalName” and “Write servicePrincipalName”
Click OK. Click OK. Click OK.
Restart your SQL service!
Check the configuration with the following command SetSPN -L <AD Sql Service Account name> the output should be something like:
Registered ServicePrincipalNames for CN=svSQL,OU=ServiceAccounts,OU=People,OU=RHCS,DC=rhcs,DC=nl: