SCCM 2012 strange SQL errors

[yukis1]

Hi guys,

I have installed SCCM 2012 RC2 on top of SQL 2008 R2 SP1 CU4.

Everything was working well, when all of the sudden I started experiencing very strange errors.

For instance, when I try to create an application, i fails with a SMS Provider error, and the SMSPROV.log says:

 

*** *** Unknown SQL Error! SMS Provider 26/03/2012 18:19:22 4188 (0x105C)

*** if (object_id('tempdb..#sp_setupci_resultstr') IS NOT NULL) select * from #sp_setupci_resultstr; else select N''; SMS Provider 26/03/2012 18:19:22 4188 (0x105C)

*** [24000][0][Microsoft]

Invalid cursor state	SMS Provider	26/03/2012 18:19:22	4188 (0x105C)

*** if (object_id('tempdb..#sp_setupci_resultstr') IS NOT NULL) select * from #sp_setupci_resultstr; else select N'';;~ if (object_id('tempdb..#sp_setupci_resultstr') IS NOT NULL) drop table #sp_setupci_resultstr; SMS Provider 26/03/2012 18:19:22 4188 (0x105C)

*** [24000][0][Microsoft][sql Server Native Client 10.0]Invalid cursor state SMS Provider 26/03/2012 18:19:22 4188 (0x105C)

*~*~e:\nts_sccm_release\sms\siteserver\sdk_provider\smsprov\ssputility.cpp(2105) : SQL command failed: if (object_id('tempdb..#sp_setupci_resultstr') IS NOT NULL) drop table #sp_setupci_resultstr;~*~* SMS Provider 26/03/2012 18:19:22 4188 (0x105C)

*~*~SQL command failed: if (object_id('tempdb..#sp_setupci_resultstr') IS NOT NULL) drop table #sp_setupci_resultstr; ~*~* SMS Provider 26/03/2012 18:19:22 4188 (0x105C)

ERROR: SQL command failed: if (object_id('tempdb..#sp_setupci_resultstr') IS NOT NULL) drop table #sp_setupci_resultstr; SMS Provider 26/03/2012 18:19:22 4188 (0x105C)

 

Also, when I try to synchronize the WSUS, it fails and the WSYNCMGR.log says:

*** declare @rc int, @errxml xml; EXEC @rc=sp_SetupCI 16821644, 0, @errxml out; select @rc, @errxml SMS_WSUS_SYNC_MANAGER 26/03/2012 18:23:56 3972 (0x0F84)

*** *** Unknown SQL Error! SMS_WSUS_SYNC_MANAGER 26/03/2012 18:23:56 3972 (0x0F84)

Failed to sync update c6c5daa4-1aeb-409d-b5d2-fe71e3012b5e. Error: Failed to save update d2579ed4-3818-4fce-b2db-6481b004cae0. CCISource error: -1. Source: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.UpdatesManager.UpdatesManagerClass.DefineUpdate SMS_WSUS_SYNC_MANAGER 26/03/2012 18:23:57 3972 (0x0F84)

 

From what I understand, every time SCCM tries to write something into the SCCM it fails, and its really weird because I can create collection for examples.

I have tried re installing the SQL server but that didn't help, I've tryed re installing the SMS Provider with no luck...

 

It looks like some kind of an issue with permission, but nothing changed.

I see the SCCM computer account has access rights to the DB on SQL.

Could it be something with the NTFS permissions?

 

Any help will be appreciated.