FAQShop.com : "Error. Access denied." Message when Trying to Run Web Reports

"Error. Access denied." Message when Trying to Run Web Reports

Setup SMS 2003 with no problems. Client installs all working, data collection going great. But I can't get any reports. I've enable the server as a reporting site (on the same machine as SMS), but when I run a report I get a page not found error with this in the address bar:

http://mis-utl-001/SMShygreports/PageNotFound.asp?404;http://mis-utl-001/SMShygreports/Reports.asp

So I installed the admin utils on another machine and tried running a report. I get "Error. Access denied." with this in the address bar

'http://mis-utl-001/SMShygreports/Reports.asp?ReportId=63

I've checked the permissions in IIS and on the drive and everything looks ok (admin group, SMS reporting group full access).

Almost there.

First off, when SMS installs the reporting site, it puts a double "\\" in the path, and because of that the permissions dialogue doesn't work in IIS (on 2003). So there's a bug.

I had to enable session state in the website. Unless its enabled on the top level it won't propagate down. Another little bug.

During install, I used standard security. SMS created an account on SQL but did not give it any permissions to the SMS database, I had to do that manually. Kinda of stupid it only goes 50% of the way.

Still haven't figured out why I get access denied when I run a report from a remote machine.

Contributed By: Alex Morozov
I solved the problem when I added an alias name for the default web site in IIS. The alias name is the NetBIOS name of the SMS Reporting Point computer. In your case it should be "mis-utl-001"

To see other SMS 2003 Troubleshooting FAQs click here.