question

appuser10-6231 avatar image
0 Votes"
appuser10-6231 asked Amandayou-MSFT commented

Console crash after selecting autoenroll collection comangement

SCCM - Win 10 I have a client that recently installed 2103 and they are getting the following when attempting to enable automatic enrollment in Intune.  The SMSProvider log states the following after we attempt to set "Automatic enrollment in Intune" = Pilot and select a collection for the enrollment feature:    ~~..\sspCoMgmtConfigs.cpp(253) : SQL command failed: ~    SQL Error: [42000][8169][Microsoft][SQL Server Native Client 11.0][SQL Server]Conversion failed when converting from a character string to uniqueidentifier.~~  So far we have only attempted to close the console and retry the action.  Not sure if the "conversion failed..." message is a common issue.109194-captureco.jpg


mem-cm-general
captureco.jpg (63.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Amandayou-MSFT avatar image
0 Votes"
Amandayou-MSFT answered Amandayou-MSFT commented

Hi @appuser10-6231

According to the error screenshot, it seems that there is something wrong with SQL. It is possible that SQL was not stable at the time. We could retry it to check if the problem is solved.

Could we know the operation of co-management has been set, and we just reset it or other?

If we reset it, please check if we use the last account, if not, use the following permissions to complete tasks:

An account that's a domain admin on your on-premises infrastructure
An account that's a full administrator for all scopes in Configuration Manager
An account that's a global administrator in Azure Active Directory (Azure AD)



If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I ended up removing the co management configuration and "simply" re-added the configuration. The site was migrated. Site consolidation from CAS to Primary (I didn't perform the consolidation). It seemed that the co management configuration was somehow migrated but was lacking the configured staging collection(s) as well.
I think the database didn't know how to handle the re specification of the staging collection as well as the configuration of the auto enroll collection.
Setting saved fine after the newly Configured co management config was configured...

0 Votes 0 ·

Hi,

Thank you very much for the update and we're glad the problem is solved through the newly Configured co management config was configured. If you have any questions in future, we warmly welcome you to post in Q&A again.

Have a nice day!

Regards,
Amanda

0 Votes 0 ·