locked
Microsoft SQL Server reported SQL message 229, severity 14 RRS feed

  • Question

  • Hi,

    I´m having this error msg in my SCCM 2012 did anyone seen this before:

    The sccm computer account is local admin in the SQL Server!

    Error message:

    Microsoft SQL Server reported SQL message 229, severity 14: [42000][229][Microsoft][SQL Server Native Client 10.0][SQL Server]The EXECUTE permission was denied on the object 'spRemoveDeletedSiteSystemSummary', database 'DatabaseName', schema 'dbo'. : spRemoveDeletedSiteSystemSummary

    Thanks!


    Rodrigo Daphanis

    Friday, July 6, 2012 2:42 PM

All replies

  • Local Admin is not enought it need to be DBO within SQL too?

    http://www.enhansoft.com/

    Sunday, July 8, 2012 8:56 PM
  • Hi Garth,

    The account is DBO with SQL also...

    Thanks!


    Rodrigo Daphanis

    Monday, July 9, 2012 1:42 PM
  • I’m cleaning up my inbox and I see that I don’t reply to this, did you figure it out?


    http://www.enhansoft.com/

    Wednesday, July 25, 2012 2:23 AM
  • I'm having the same issue.  Did you find a resolution?  The only component reporting the problem is the application catalog website point.
    Saturday, August 25, 2012 1:05 PM
  • Anyone already figured this out? Got same issue.

    • Edited by Niels Br Monday, September 24, 2012 3:03 PM
    Monday, September 24, 2012 3:03 PM
  • I have the same Problem.

    Database is located on a different Server (Datebase-Server)

    Don't know how to handle this

    Tuesday, July 8, 2014 6:35 AM
  • What exactly you are trying to do and where do you see this message ?

    A bit more information about your setup will be helpful..


    Kindly mark as answer/Vote as helpful if a reply from anybody helped you in this forum. Delphin

    Tuesday, July 8, 2014 10:31 AM
  • Has anyone been able to resolve this issue?

    Thursday, June 23, 2016 9:20 AM
  • Has anyone been able to resolve this issue?


    What have you done to fix it?

    Garth Jones

    Blog: http://www.enhansoft.com/blog Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleased

    Thursday, June 23, 2016 12:13 PM