Asked by:
Microsoft SQL Server reported SQL message 229, severity 14

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
- Moved by Joyce Wang [MSFT]Microsoft employee Tuesday, July 10, 2012 12:02 AM (From:Configuration Manager 2012 - General)
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