MIM 2016: Reporting initial sync will not work

Issue

I am installing MIM Reporting. I run the powershell program Start-MIMReportingInitialSync. When I look in the MIM Portal, reporting job object, I see the error “Cannot generate SSPI context”. When I look in the eventvwr I see this error message

The FIM Reporting ETL job failed while making a call to the System Center Service Manager Management Server SDK service.  This could be caused by a network or service interruption which is preventing communication between the FIM Service and the System Center Service Manager SDK Service, or by an internal error within System Center……”

Cause

MIM cannot contact the SQL server because the spns are not correct.

Solution

I used the machine account (NTService\myservername) for the SQL service logon accounts. I changed that to a domain account. Then I deleted the SQL service spns associated with the server name and set it to the domain name I used. Error was gone

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s