Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Anonymous access in SQL RS 2008 Expand / Collapse
Author
Message
Posted Tuesday, October 20, 2009 12:43 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, May 26, 2014 6:45 AM
Points: 383, Visits: 182
Hi
In SSRS 2008 their is no IIS required.
So anonymous access is not possible by configuring IIS.

I find the way to do that in SSRS 2008 .I am sharing this so that others can use it.

I am attaching the word document having steps to be followed and one more file name
microsoft.samples.reportingservices.anonymoussecurity.txt . Please rename the extension to .dll file and use this dll file as per the steps given in word document.


Thanks and Regards,
Prasad.


  Post Attachments 
Reporting Services 2008 - Anonymous Access.docx (1,210 views, 20.81 KB)
microsoft.samples.reportingservices.anonymoussecurity.txt (915 views, 24.00 KB)
Post #805464
Posted Tuesday, October 20, 2009 4:53 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, November 14, 2014 7:14 AM
Points: 6,625, Visits: 1,876
What would probably be better is if you wrote an article or blogged about it. That would make it more accessible.


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #806178
Posted Wednesday, January 20, 2010 1:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 3, 2014 7:45 AM
Points: 2, Visits: 160
Hi,
I did all from your document, but i keep getting error

Service Unavailable

--------------------------------------------------------------------------------

HTTP Error 503. The service is unavailable.


for ReportManager


and
The website cannot display the page

or rsconfigurationerror.
For ReportServer.
Where i'm wrong?
can any one help me, please.
Thank you.
Post #850272
Posted Wednesday, January 27, 2010 3:38 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, May 26, 2014 6:45 AM
Points: 383, Visits: 182
Hi,

You should Stop the Report server and do the changes in the files and once the changes done you need to start the Report server.

You can stop and Start the Report server from "Reporting Services Configuration Manager"

The path of "Reporting Services Configuration Manager" is Start --> Programs --> Microsoft SQL Server 2008 -->Configuration Tools -->Reporting Services Configuration Manager.

Thanks and Regards,
Prasad

Post #854269
Posted Friday, February 5, 2010 3:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 12, 2012 7:59 AM
Points: 4, Visits: 24
Hello ,
It worked pefect for opening folders.Thanks for that.
But when I open report it display:

An internal error occurred on the report server. See the error log for more details. (rsInternalError)
Could not load file or assembly 'Microsoft.ReportingServices.ProcessingObjectModel, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied

I solved first problem .
Need to get access to these folders:;
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files
C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\RSTempFiles
Now works.

And also: can I give only browser Role for this anonymous access ?
Post #860301
Posted Wednesday, March 3, 2010 4:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 3, 2010 4:06 AM
Points: 1, Visits: 2
Hi all,
I did all the thing sgiven in the doc file, but when i tried to access the report manager, it gives an error.

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

I checked the server, it running fine then why this error occuring???

Any Idea???

Thanks in advanced..

-Kaustubh
Post #875804
Posted Thursday, March 11, 2010 11:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 11, 2010 11:53 PM
Points: 1, Visits: 2
Just wanted to let you know that the configuration works perfectly!

Thanks a lot!!!
Post #881510
Posted Monday, March 22, 2010 11:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 24, 2010 10:24 AM
Points: 1, Visits: 5
Same problem

it gives an error.

The report server is not responding. Verify that the report server is running and can be accessed from this computer.
Post #887509
Posted Monday, April 12, 2010 7:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 12, 2010 7:52 AM
Points: 1, Visits: 4
This is working for me.

Thanks alot for this document / .dll file.

Best Regards,
Abhishek
Post #901617
Posted Monday, April 12, 2010 8:00 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 3:04 AM
Points: 947, Visits: 2,741
K. Brian Kelley (10/20/2009)
What would probably be better is if you wrote an article or blogged about it. That would make it more accessible.

On top of that this is posted in the wrong forum so it is not likely to be found very easily.


Shawn Melton
PS C:\>(Find-Me).TwitterURL
@wsmelton
PS C:\>(Find-Me).BlogURL
meltondba.wordpress.com
Post #901626
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse