SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Anonymous access in SQL RS 2008


Anonymous access in SQL RS 2008

Author
Message
vasamsetti_prasad
vasamsetti_prasad
SSC-Addicted
SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)

Group: General Forum Members
Points: 407 Visits: 188
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.
Attachments
K. Brian Kelley
K. Brian Kelley
Keeper of the Duck
Keeper of the Duck (10K reputation)

Group: Moderators
Points: 10194 Visits: 1917
What would probably be better is if you wrote an article or blogged about it. That would make it more accessible.

K. Brian Kelley
@‌kbriankelley
jozelazarevski
jozelazarevski
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 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.
vasamsetti_prasad
vasamsetti_prasad
SSC-Addicted
SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)

Group: General Forum Members
Points: 407 Visits: 188
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
tony_bulg
tony_bulg
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 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 ?
kaustubhwadi
kaustubhwadi
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 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
kaare_t
kaare_t
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 2
Just wanted to let you know that the configuration works perfectly!

Thanks a lot!!!
schag06
schag06
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 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.
lko.abhishek
lko.abhishek
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 4
This is working for me.

Thanks alot for this document / .dll file.

Best Regards,
Abhishek
Shawn Melton
Shawn Melton
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2225 Visits: 3512
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.:-D

Shawn Melton
PS C:\>(Find-Me).TwitterURL
@wsmelton
PS C:\>(Find-Me).BlogURL
meltondba.wordpress.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search