Home

Products
       NCAA Tourney
       Loan Calculator
       Text / HTML Versioner
       HTML Fader
       HTML Scheduler
       SQL Reporting Services
       MySkype

Support & Forums
Friday, February 10, 2012 You Are Here: Support & Forums  | 
Welcome to Module Masters support forums - the primary support mechanism for our products. Feel free to post your questions, and we will aim to respond in a timely manner.  We also encourage our users to post any feedback you may have.  You may also email us directly at service@modulemasters.com
Forums > Module Masters Forum > SQL Reporting Services
Subject: HTTP status 401: Access Denied
Prev Next
You are not authorized to post a reply.

Author Messages
j_w_bartonUser is Offline

Posts:2
06/22/2007 13:30  

I am running DotNetNuke 4.5.3 and Microsoft SQL Server 2005 Express Edition reporting services.  I have downloaded the trial of the SQL reporting services module, and am attempting to set it up now.

I am at the stage of inputting the server settings.  My report server is at http://localhost/ReportServer.  I have selected "Reporting Services 2005," but am having problems authenticating through the test button.  My Reports and ReportServer virtual directories are currently configured through IIS for integrated windows authentication.  SQL server reporting services are currently set up through the networkservice builtin account.

SO, I am at a loss as to what account to put into the username/password/domain fields.  I have put in the credentials of the account I am currently using (which has no problem automatically authenticating into the reporting services site), but I keep getting There was an error: The request failed with HTTP status 401: Access Denied no matter what I do.

What do I need to do?  I don't want to change the current configuration of reporting services...I like it using integrated windows authentication.  Yet, I sure would like this module to talk to my server.

What am I missing?
hostUser is Offline

Posts:497
06/22/2007 18:14  
What you could use is a valid username /password on that machine (or domain) that has access to run reports on the reportmanager / server. If you don't run on a domain, simply use the machine name of the machine running the reporting services site. I would recommend using an account with Admin privelegs to the top level of the reporting services so that you have full access to everything on the report server and can then control security through the DNN security (e.g. setting up the permissions to view whatever you want the users to see via the module permissions and settings). Please let us know if this does not help.
j_w_bartonUser is Offline

Posts:2
06/22/2007 18:21  
Yeah, that's what I'm doing now.  I'm using my own local machine account (which is what native report services is using with automatic authentication), and I'm still not getting anywhere.
hostUser is Offline

Posts:497
06/22/2007 18:23  
can you shoot me the screenshot of the server settings you are using to service@modulemasters.com so that I can see the path to the report server, or you can paste it here. you can also try leaving domain blank if you are not on a domain.
You are not authorized to post a reply.
Forums > Module Masters Forum > SQL Reporting Services > HTTP status 401: Access Denied


ActiveForums 3.7
Copyright 2011 by Module Masters Privacy StatementTerms Of Use