Re: SCCM and Predefined Reports missing

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:
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: SCCM and Predefined Reports missing
    ... the comptuer account has access to the db ... SMSadmin group or the SMS server computer account need to have ... local admin on the SMS & SQL Server and Sysadmin to the database). ...
    (microsoft.public.sms.setup)
  • Re: Does anyone know how to fix this??
    ... > Inside the Active Directory Users and Computers in the folder of SYSTEM I ... Give the site's SMS Service account full control rights to the ... MP encountered an error when connecting to SQL Server. ...
    (microsoft.public.sms.setup)
  • Re: Adv Client with Workgroup Computers
    ... I was trying to use the SMS tools from the SMS server to initiate harware ... Inv for example the account is a domain account but the Client PC is in a ... Is there a procedure for installing the ADV client localy on a workgroup ... I have manually added to the WINS server. ...
    (microsoft.public.sms.admin)
  • Http verification .sms_aut (port 80) failed
    ... I noticed I couldn't get SMS reports to work.... ... MP encountered an error when connecting to SQL Server. ... If using a standard SQL security account, ...
    (microsoft.public.sms.admin)
  • Re: MP Control Manager Issue
    ... Is this server a DC? ... > compared all settings between the test server and the sms server have same ... MP encountered an error when connecting to SQL Server. ... If using a standard SQL security account, ...
    (microsoft.public.sms.admin)
Loading