Re: SCCM and Predefined Reports missing

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:
Greetings
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.
Is your sms site server a local admin on the sql server?

--
"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

.

Relevant Pages

  • Re: Failed to get a SQL Server connection
    ... SMS is installed on a Windows Server 2003 SP1, ... We already did SMS ... Possible cause: SQL Server problem. ... Verify that SMS can access the SMS site database. ...
    (microsoft.public.sms.setup)
  • Re: MP Control Manager detected MP is not responding to HTTP requests
    ... IIS lockdown isn't needed for Windows server 2003. ... Did you get an error status message in the SMS admin console for MP control ... The SQL server site system is turned off, ...
    (microsoft.public.sms.setup)
  • Does anyone know how to fix this??
    ... Basically sms secondary site reports me 3 kind of error.... ... This site's SMS Service account or the site server's machine ... http error is Internal Server Error. ... MP encountered an error when connecting to SQL Server. ...
    (microsoft.public.sms.setup)
  • Re: Move SMS Database to new SQL Server
    ... Because you aren't just backing up the database, you're doing a full SMS ... later and move database from a remote server back to the SMS site server.) ... >>> I have SMS running right now on its own SQL server. ...
    (microsoft.public.sms.setup)
  • Problems installing Security Scan and Office Scan
    ... I have been to the MS Managing SMS 2003 class. ... I have installed SMS 2003 on a Win2003 server and placed the database on one ... installed the SMS Provider on the SQL server. ... I initially had some problem getting the reports to install. ...
    (microsoft.public.sms.tools)
Loading