Anonymous access in SQL RS 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Security » Anonymous access in SQL RS 2008

34 posts, Page 1 of 4

1 2 3 4 »»»

Anonymous access in SQL RS 2008

Rate Topic

Display Mode

Topic Options

Author

Message

vasamsetti_prasad

Posted Tuesday, October 20, 2009 12:43 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, September 26, 2012 6:55 AM
Points: 366, Visits: 174

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,096 views, 20.81 KB)

microsoft.samples.reportingservices.anonymoussecurity.txt (836 views, 24.00 KB)

Post #805464

K. Brian Kelley

Posted Tuesday, October 20, 2009 4:53 PM

Keeper of the Duck

Group: Moderators
Last Login: 2 days ago @ 1:55 PM
Points: 6,584, Visits: 1,789

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

jozelazarevski

Posted Wednesday, January 20, 2010 1:15 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 29, 2012 2:27 PM
Points: 2, Visits: 116

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

vasamsetti_prasad

Posted Wednesday, January 27, 2010 3:38 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, September 26, 2012 6:55 AM
Points: 366, Visits: 174

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

tony_bulg

Posted Friday, February 05, 2010 3:54 AM

Forum 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

kaustubhwadi

Posted Wednesday, March 03, 2010 4:06 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 03, 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

kaare_t

Posted Thursday, March 11, 2010 11:55 PM

Forum 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

schag06

Posted Monday, March 22, 2010 11:01 AM

Forum 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

lko.abhishek

Posted Monday, April 12, 2010 7:53 AM

Forum 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

Shawn Melton

Posted Monday, April 12, 2010 8:00 AM

Right there with Babe

Group: General Forum Members
Last Login: Saturday, May 11, 2013 8:56 PM
Points: 754, Visits: 1,891

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. BigGrin

--------------------------------------------------------------
Shawn Melton
@wshawnmelton

Post #901626

« Prev Topic | Next Topic »

34 posts, Page 1 of 4

1 2 3 4 »»»

Permissions