SCCM Intune connector in unhealthy state

Thiago B Andrade 101 Reputation points
2025-06-05T19:19:41.9733333+00:00

Hi!

I´m facing a problem with SCCM connector. The state is always in Unhealty since the first attemptive to enable it.

From messages, I got:

User's image

GenericUploadWorker.logUser's image

[Critical][GenericUploadWorker_HierarchyFeatureStatus][0][System.Data.SqlClient.SqlException][0x80131904]

The SELECT permission was denied on the object 'CMGS_ReplicationTable', database 'CM_SDE', schema 'dbo'.

The SELECT permission was denied on the object 'CMGS_ReplicationState', database 'CM_SDE', schema 'dbo'.

The SELECT permission was denied on the object 'vCMGS_HierarchyFeatureInternal_Status', database 'CM_SDE', schema 'dbo'.

The SELECT permission was denied on the object 'vCMGS_HierarchyFeatureInternal_Status', database 'CM_SDE', schema 'dbo'. at System.Data.SqlClient.SqlCommand.EndExecuteReaderAsync(IAsyncResult asyncResult)

at System.Threading.Tasks.TaskFactory1.FromAsyncCoreLogic(IAsyncResult iar, Func2 endFunction, Action1 endAction, Task1 promise, Boolean requiresSynchronization)

--- End of stack trace from previous location where exception was thrown ---

at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

at Microsoft.ConfigurationManager.ServiceConnector.GenericUploadWorker.<ReadAsync>d__21.MoveNext()

--- End of stack trace from previous location where exception was thrown ---

at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

at Microsoft.ConfigurationManager.ServiceConnector.GenericWorkerBase.<ReadWriteInBatchesAsync>d__74.MoveNext()

--- End of stack trace from previous location where exception was thrown ---

at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

at Microsoft.ConfigurationManager.ServiceConnector.GenericWorkerBase.<ReadWriteInBatchesAsync>d__74.MoveNext()

--- End of stack trace from previous location where exception was thrown ---

at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

at Microsoft.ConfigurationManager.ServiceConnector.GenericWorkerBase.<DoWorkerTasksAsync>d__73.MoveNext()

--- End of stack trace from previous location where exception was thrown ---

at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

at Microsoft.ConfigurationManager.ServiceConnector.GenericWorkerBase.<DoWorkAsync>d__66.MoveNext()

Could anyone give a direction to this? Any other logs to get?

SCCM 2409

Thamks,

Thiago

Microsoft Intune Configuration
Microsoft Intune Configuration
Microsoft Intune: A Microsoft cloud-based management solution that offers mobile device management, mobile application management, and PC management capabilities.Configuration: The process of arranging or setting up computer systems, hardware, or software.
2,089 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anup kumar 0 Reputation points
    2025-06-07T16:45:23.04+00:00

    Hello Thiago,

    it's seems you are lacking SQL permission, can you check the permission is appropriate in SQL database.

    Open SQL Server Management Studio (SSMS).

    Navigate to Security > Users.

    Locate the user account executing the query.

    Ensure it has the necessary SELECT permissions on the affected tables.

    for my information can you confirm below if

    if Tenant Attach is enabled in SCCM.

    Check if Hybrid AD Join is configured with SCCM.

    Look at SCCM logs to see if Intune is pulling data from SCCM.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.