locked
SMS_Package_Transfer_Manager Error 619 SQL Message 229, Severity 14 Woes! RRS feed

  • Question

  • Hi folks!

    I've been getting these two messages repeating hundreds and hundreds of times in my SCCM 2012r2 (no CU's) Standalone with local SQL 2012, on Windows Server 2012r2. I see this under Component Status for SMS_Package_Transfer_Manager.

    I consistently get these errors:

    Microsoft SQL Server reported SQL message 229, severity 14: [42000][229][Microsoft][SQL Server Native Client 11.0][SQL Server]The EXECUTE permission was denied on the object 'fnGetRelatedContentID', database 'CM_XYZ', schema 'dbo'.
    
    Microsoft SQL Server reported SQL message 229, severity 14: [42000][229][Microsoft][SQL Server Native Client 11.0][SQL Server]The SELECT permission was denied on the object 'SC_SiteDefinition', database 'CM_XYZ', schema 'dbo'.

    When I look at the properties of the "SC_SiteDefinition" object, the user "smsdbrole_DmpConnector" is listed to have Select permissions (there are two rows that say Select also)

    Any thoughts?


    • Edited by JWeinberg Friday, August 29, 2014 6:13 PM
    Friday, August 29, 2014 6:08 PM

All replies

  • You should compare it to a working site (testlab). I have no console next to me right now, but I guess SYSTEM need execute permissions.

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

    • Proposed as answer by Joyce L Monday, September 1, 2014 2:15 AM
    • Unproposed as answer by JWeinberg Wednesday, October 1, 2014 5:04 PM
    Friday, August 29, 2014 8:03 PM
  • Sadly, no testlab available. I did have another user of SCCM 2012r2 check in SQL Server Management Studio, and the listed user matched mine.

    EDIT: Completely separate install of SCCM 2012r2, we aren't at the same company.

    • Edited by JWeinberg Tuesday, September 2, 2014 7:21 PM
    Tuesday, September 2, 2014 4:56 PM
  • Did anyone ever make progress on this? I can confirm we are seeing this error intermittently as well.

    Will

    Saturday, November 15, 2014 4:35 AM
  • I haven't.
    Monday, November 17, 2014 7:34 PM