Re: SCCM and Predefined Reports missing
- From: "GeorgeBR" <me@xxxxxx>
- Date: Thu, 13 Dec 2007 14:41:38 -0400
Hi Cathy
Checked that and it's there. We tried removing and reinstalling the
reporting point, resetting the site, adding everyone full control to the
DCOM security on the SQL box and other than these errors - "Error 80041001
(Error occured while storing the data)" or "The ConfigMgr Provider reported
an error" , we don't see any events in the logs on either box or anything
abnormal in the SQL server profiler.
Could it be anything to do with something totally in the other direction
like website certificates?
"Cathy Moya [MS]" <camoya@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23yZ8x2aPIHA.1188@xxxxxxxxxxxxxxxxxxxxxxx
http://technet.microsoft.com/en-us/library/bb680595.aspx
The site server account requires "membership in Sysadmins on the SQL
Server, if the site database is on a remote computer."
--
Cathy Moya, CISSP, MCSE: Security
Technical Writer, Management & Solutions Division User Assistance
Check out the SMS Technical FAQ:
http://www.microsoft.com/technet/prodtechnol/sms/sms2003/techfaq/default.mspx
Read the Configuration Manager 2007 Documentation Library
http://technet.microsoft.com/en-us/library/bb694263.aspx
This posting is provided AS IS with no warranties and confers no rights.
"GeorgeBR" <GeorgeBR@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:808C0CBC-0552-4D44-BC25-77638A1F31B1@xxxxxxxxxxxxxxxx
Hi Kim;
Correction to the last statement, the comptuer account has access to the
db
as db_owner, smsdbrole_ (mp, rp, siteserver, SLP), My bad. Does the
SMSAdmin
group require any access, I don't see that one in there....
"GeorgeBR" wrote:
Hi Kim,
Thanks agian for the reply. Yes, the SMS server's computer account has
local admin rights to the SQL server. I'm wondering though, does the
SMSadmin group (local on SQL) or the SMS server computer account need to
have
rights to the DB? So far, only the account that setup SMS has Sysadmin
to
the DB.
"Kim Oppalfens [MVP]" <""Kim dot Oppalfen" wrote:
GeorgeBR wrote:
GreetingsIs your sms site server a local admin on the sql server?
We have setup SCCM with a single site server and an external SQL DB
(I never
did it this way before). The problem we are getting is that the
"Canned"
reports are not appearing after setting up the Reporting Point (site
server's
IIS). I tried to create one manually, and, import a MOF from the
"Sandbox
SCCM" and I get an Error 80041001 (Error occured while storing the
data). Is
there any security or any other DCOM settings I need to adjust on
the SQL
server? I am running the console from the SMS server logged in as
the
install account (full access to everything as far as I can tell,
including
local admin on the SMS & SQL Server and Sysadmin to the database).
Cheers.
GB.
--
"Everyone is an expert at something"
Kim Oppalfens - Sms Expert for lack of any other expertise
Windows Server System MVP - SMS
http://www.blogcastrepository.com/blogs/kim_oppalfenss_systems_management_ideas/default.aspx
.
- References:
- Re: SCCM and Predefined Reports missing
- From: Kim Oppalfens [MVP]
- Re: SCCM and Predefined Reports missing
- From: GeorgeBR
- Re: SCCM and Predefined Reports missing
- From: GeorgeBR
- Re: SCCM and Predefined Reports missing
- From: Cathy Moya [MS]
- Re: SCCM and Predefined Reports missing
- Prev by Date: Re: SCCM and Predefined Reports missing
- Next by Date: Re: SCCM and Predefined Reports missing
- Previous by thread: Re: SCCM and Predefined Reports missing
- Next by thread: Re: SCCM and Predefined Reports missing
- Index(es):
Relevant Pages
|
Loading
