RE: SMS 2003 Reporting does not work

Hello Maureen,

Could you be more specific in telling us what URL you type in.
Also do you get this same error when launching the Report Viewer from the
Admin Console ?

thanks,

Sai

This posting is provided "AS IS" with no warranties, and confers no rights.

"Maureen M" wrote:

Drats! I added the users to the SQL server local Distributed COM Users
group, but still no go. Do i need to do an iisreset after this change or
anything?

I type the url into my browser, hit enter, and get the error right then and
there. Thank you so much for helping me with this - i sure hope i can get it
solved!
--
Systems Administrator
Northern Arizona University


"Sai Wong [MSFT]" wrote:

Hello Maureen,

Could you give me more details regarding the steps to repro this problem.
Do you get this problem when trying to launch to the Report Viewers main page
or do you get the problem when you acually run a specific report ?

If it is the latter and you get a 500 error after some time if could be an
AspBufferingLimit issue. Please see the FAQ below.

http://www.microsoft.com/technet/prodtechnol/sms/sms2003/techfaq/tfaq10.mspx

Also I believe there were some security changes in Windows 2003 SP1 that
defaulted to only allowing 'Administrators' DCOM permissions.

Add your user to the 'Distributed COM Users' local group on the SQL server
machine

Sai

This posting is provided "AS IS" with no warranties, and confers no rights.

"Maureen M" wrote:

Hello,

I am running Windows 2003 server, SP1, SMS 2003 SP1, and my reporting just
doesn't work. The web page responds with a 500 Internal Server Error.

I have the reporting point enabled.
I have a local SMS Reporting Users group, populated with users.
I have given the users security access in SMS to Read all instances of the
class Report.
I have run dcomcnfg and given the SMS reporting users Local Activation
permission.
I have removed the "\\" for the local path in IIS.
I do not have anonymous access turned on.
I do have Basic authentication selected. I have selected my default domain
and realm.
I ran an SMS site reset.

This used to work. Please! Help!

--
Systems Administrator
Northern Arizona University
.

Relevant Pages

  • RE: SMS 2003 Reporting does not work
    ... Systems Administrator ... Northern Arizona University ... Do you get this problem when trying to launch to the Report Viewers main page ... I have run dcomcnfg and given the SMS reporting users Local Activation ...
    (microsoft.public.sms.admin)
  • Re: report view error
    ... Are you a member of the sms reporting users group? ... Kim Oppalfens ... > have IIS 6.0 running. ... When I try to view a report I ...
    (microsoft.public.sms.setup)
  • Re: report view error
    ... >Are you a member of the sms reporting users group? ... >Kim Oppalfens ... >> have IIS 6.0 running. ... >> but I cannot access my report views. ...
    (microsoft.public.sms.setup)
  • http error 404 when running sms report
    ... I got http error 404-file or deirctory not found error when running sms 2003 report. ... Check the smsreporinginstall.log, and it says error running wmswwwroot.vbs script, and check the local user and group, the SMS Reporting Users does not exist. ...
    (microsoft.public.sms.inventory)
  • Re: Error if I launch a Parameter Report from a Text box and cancel it
    ... canceling the previous command. ... In the routine where you're launching the report, ...
    (microsoft.public.access.gettingstarted)
Loading