none
Application Create SMS Provider Error after database move

    Question

  • When creating a new application the wizard fails with the following error message:
    Error: The SMS Provider reported an error
    SMS Provider is installed on seperat SQL Server 2008 R2
    Seems like the issue occured after moving the database form c:\ to d:\ path

    SMSProvider.log:

    Unknown SQL Error!  ThreadID : 4692 , DbError: 0 , Sev: 0~*~*~  $$<SMS Provider><04-27-2012 12:02:43.351-120><thread=4692 (0x1254)>
    *** 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><04-27-2012 12:02:43.351-120><thread=4692 (0x1254)>
    *** [24000][0][Microsoft][SQL Server Native Client 10.0]Invalid cursor state  $$<SMS Provider><04-27-2012 12:02:43.351-120><thread=4692 (0x1254)>
    ~*~*~[24000][0][Microsoft][SQL Server Native Client 10.0]Invalid cursor state   [24000][0][Microsoft][SQL Server Native Client 10.0]Invalid cursor state  ThreadID : 4692 , DbError: 0 , Sev: 0~*~*~  $$<SMS Provider><04-27-2012 12:02:43.351-120><thread=4692 (0x1254)>
    ~*~*~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;~ SQL Error: [24000][0][Microsoft][SQL Server Native Client 10.0]Invalid cursor state~*~*~  $$<SMS Provider><04-27-2012 12:02:43.351-120><thread=4692 (0x1254)>
    ~*~*~SQL command failed:  if (object_id('tempdb..#sp_setupci_resultstr') IS NOT NULL)  drop table #sp_setupci_resultstr; [24000][0][Microsoft][SQL Server Native Client 10.0]Invalid cursor state~*~*~  $$<SMS Provider><04-27-2012 12:02:43.351-120><thread=4692 (0x1254)>
    ERROR: SQL command failed:  if (object_id('tempdb..#sp_setupci_resultstr') IS NOT NULL)  drop table #sp_setupci_resultstr;~  $$<SMS Provider><04-27-2012 12:02:43.351-120><thread=4692 (0x1254)>


    Friday, April 27, 2012 1:01 PM

Answers

  • Reinstalled SCCM in case it was just a Lab enviroment. I think the issue was the database move. Now everythink works fine.

    • Marked as answer by concomet Friday, May 11, 2012 9:55 AM
    Friday, May 11, 2012 9:55 AM

All replies

  • How did you "move" the database?

    Jason | http://blog.configmgrftw.com | Twitter @JasonSandys

    Friday, April 27, 2012 2:12 PM
    Moderator
  • first i dettached the database, then i moved the files after that i attached the database again and set the trustworthy option

    seems everything worked, except i creating application. creating pakets like in the old sccm 2007 days works.


    • Edited by concomet Friday, April 27, 2012 5:08 PM
    Friday, April 27, 2012 4:52 PM
  • Reinstalled SCCM in case it was just a Lab enviroment. I think the issue was the database move. Now everythink works fine.

    • Marked as answer by concomet Friday, May 11, 2012 9:55 AM
    Friday, May 11, 2012 9:55 AM
  • Any chance that you were experiencing this issue: http://support.microsoft.com/kb/2709082?

    Torsten Meringer | http://www.mssccmfaq.de

    • Proposed as answer by RVTelLux Wednesday, August 08, 2012 2:46 PM
    Friday, May 11, 2012 10:30 AM
  • Hi,

    I am having the same issue and no luck using the solution from http://support.microsoft.com/kb/2709082 although the symptoms are the same, setting the ALTER DATABASE <ConfigMgr DB> SET TRUSTWORTHY ON runs successfully but no change.

    The other two settings

    ALTER DATABASE <ConfigMgr DB>
     SET ALLOW_SNAPSHOT_ISOLATION ON

    ALTER DATABASE <ConfigMgr DB>
     SET READ_COMMITTED_SNAPSHOT ON

    are not required, checked and they seem to have the correct values.

    What else can I check?

    PS I am new to SCCM and this is in a testing phase, not used in production.

    Thanks.


    http://mariusene.wordpress.com/

    Friday, May 03, 2013 9:43 PM
  • Given that that's a Microsoft CSS supplied solution, you should contact them if it's not working for you.

    Jason | http://blog.configmgrftw.com

    Friday, May 03, 2013 9:54 PM
    Moderator
  • Well, I guess I could do that, but by the time I would get an answer I'd be better off reinstalling CM, since its not in production. 

    There must be something I am missing...this is part of the smsprov.log. Are there any other logs I can check?

    Updating SDM content definition.  $$<SMS Provider><05-04-2013 01:13:28.148-180><thread=3472 (0xD90)>
    *** declare @rc int, @errxml xml; EXEC @rc=sp_SetupCI 16780320, 0, @errxml out; select @rc, @errxml  $$<SMS Provider><05-04-2013 01:13:29.233-180><thread=3472 (0xD90)>
    *** *** Unknown SQL Error!  $$<SMS Provider><05-04-2013 01:13:29.234-180><thread=3472 (0xD90)>
    ~*~*~*** Unknown SQL Error!     ThreadID : 3472 , DbError: 50000 , Sev: 16~*~*~  $$<SMS Provider><05-04-2013 01:13:29.234-180><thread=3472 (0xD90)>
    *** if (object_id('tempdb..#sp_setupci_resultstr') IS NOT NULL) select * from #sp_setupci_resultstr; else select N'';  $$<SMS Provider><05-04-2013 01:13:29.234-180><thread=3472 (0xD90)>
    *** [24000][0][Microsoft][SQL Server Native Client 10.0]Invalid cursor state  $$<SMS Provider><05-04-2013 01:13:29.234-180><thread=3472 (0xD90)>
    ~*~*~[24000][0][Microsoft][SQL Server Native Client 10.0]Invalid cursor state   *** Unknown SQL Error!  ThreadID : 3472 , DbError: 0 , Sev: 0~*~*~  $$<SMS Provider><05-04-2013 01:13:29.234-180><thread=3472 (0xD90)>
    *** 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><05-04-2013 01:13:29.234-180><thread=3472 (0xD90)>
    *** [24000][0][Microsoft][SQL Server Native Client 10.0]Invalid cursor state  $$<SMS Provider><05-04-2013 01:13:29.234-180><thread=3472 (0xD90)>
    ~*~*~[24000][0][Microsoft][SQL Server Native Client 10.0]Invalid cursor state   [24000][0][Microsoft][SQL Server Native Client 10.0]Invalid cursor state  ThreadID : 3472 , DbError: 0 , Sev: 0~*~*~  $$<SMS Provider><05-04-2013 01:13:29.235-180><thread=3472 (0xD90)>
    ~*~*~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;~ SQL Error: [24000][0][Microsoft][SQL Server Native Client 10.0]Invalid cursor state~*~*~  $$<SMS Provider><05-04-2013 01:13:29.235-180><thread=3472 (0xD90)>
    ~*~*~SQL command failed:  if (object_id('tempdb..#sp_setupci_resultstr') IS NOT NULL)  drop table #sp_setupci_resultstr; [24000][0][Microsoft][SQL Server Native Client 10.0]Invalid cursor state~*~*~  $$<SMS Provider><05-04-2013 01:13:29.235-180><thread=3472 (0xD90)>
    ERROR: SQL command failed:  if (object_id('tempdb..#sp_setupci_resultstr') IS NOT NULL)  drop table #sp_setupci_resultstr;~  $$<SMS Provider><05-04-2013 01:13:29.235-180><thread=3472 (0xD90)>
    Auditing: User EUROPE\adm_iene called an audited method of an instance of class SMS_Application.~  $$<SMS Provider><05-04-2013 01:13:29.280-180><thread=3472 (0xD90)>
    CExtUserContext::LeaveThread : Releasing IWbemContextPtr=85209088~  $$<SMS Provider><05-04-2013 01:13:29.280-180><thread=3472 (0xD90)>


    http://mariusene.wordpress.com/


    Friday, May 03, 2013 10:17 PM
  • got it...it works...

    sp_changedbowner 'sa' ...I was sure I missed something..

    Thanks guys!


    http://mariusene.wordpress.com/

    Friday, May 03, 2013 10:27 PM