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


A Guide to Installing SQL Server 2008 R2 Reporting Services


A Guide to Installing SQL Server 2008 R2 Reporting Services

Author
Message
Basit Farooq
Basit Farooq
SSC-Enthusiastic
SSC-Enthusiastic (193 reputation)SSC-Enthusiastic (193 reputation)SSC-Enthusiastic (193 reputation)SSC-Enthusiastic (193 reputation)SSC-Enthusiastic (193 reputation)SSC-Enthusiastic (193 reputation)SSC-Enthusiastic (193 reputation)SSC-Enthusiastic (193 reputation)

Group: General Forum Members
Points: 193 Visits: 818
Comments posted to this topic are about the item A Guide to Installing SQL Server 2008 R2 Reporting Services

Regards,

Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)

http://basitaalishan.com
peter.row
peter.row
SSC-Addicted
SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)

Group: General Forum Members
Points: 483 Visits: 405
Installation of RS, I found, was actually pretty trivial without knowing that much.
The problems comes when you actually try to use it or integrate it.

Need to use it over the internet? Write your own custom security extension.
Want to use Report Builder 3 over the internet with a Data Model? Better make such you fiddle the app.config because there is a school boy error of using 1 connection for everything and never closing it so using the wizard to create a new report crashes the app. Had to ring MS support for that nugget - despite everyone telling me it was my custom security extension Crying
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27045 Visits: 13268
This article doesn't tell me much more than MSDN.
I would have liked a more in-depth discussion on some configuration topics, such as the service account (using a built-in one - which one? - or a domain account).


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
SQLPhil
SQLPhil
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1568 Visits: 740
A nice article providing step-by-step instructions (although I haven't quite figured out what the light bulbs are for??)

But I agree with Koen, perhaps something that highlighted potential gotchas when installing SSRS 2008. For instance, when installing on W2K8 server (which for some reason isn't included in the list of supported Server OS's) and running Report Manager for the first time, you can get some permission denied errors. This can be overcome by running IE as administrator and then navigating to the Report Manager URL and then configuring permissions.

Other suggestions might be installing and configuring a scale-out deployment.

Oh, and IIS is not required for SSRS 2008.
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27045 Visits: 13268
SQLPhil (2/14/2012)
Other suggestions might be installing and configuring a scale-out deployment.


Indeed. For example, the databases on one server, the webservices on another web server and so on...


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
rfr.ferrari
rfr.ferrari
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1529 Visits: 13627
very good article, easy understanding of explanation!!!
thanks!


rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

sethwainer
sethwainer
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: 15
i'm having a really hard time getting access over the internet with my AWS instance. I can set up the reportserver and access it locally just fine, but accessing it from the interwebs is proving really frustrating.

i've checked the windows firewall, opened port 80 on reports. I'm curious if other people have issues with AWS. could be a security thing on the console, or it could be that i can't get the dang public IP right. any help appreciated.
peter.row
peter.row
SSC-Addicted
SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)

Group: General Forum Members
Points: 483 Visits: 405
sethwainer (2/14/2012)
i'm having a really hard time getting access over the internet with my AWS instance. I can set up the reportserver and access it locally just fine, but accessing it from the interwebs is proving really frustrating.

i've checked the windows firewall, opened port 80 on reports. I'm curious if other people have issues with AWS. could be a security thing on the console, or it could be that i can't get the dang public IP right. any help appreciated.


Remember that out of the box Reporting Services only has Windows Authentication which isn't going to work across the internet unless you happen to have a user local to the Reporting Services server with the same username and password. Alternatively set up custom authentication.
sethwainer
sethwainer
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: 15
Yeah, I appreciate that. I guess what i mean is, i've set up ssrs before on Rackspace instances, and gotten everything to work fine so an outside user can get their reports.

Now that i'm trying it on AWS, I can only access the reports when I am remoted in, not from outside. Doesn't seem to be a firewall issue, but I was curious if anyone had any experience with this same problem.
dati
dati
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 Visits: 14
Please Help!

How do you use Active Directory with SSRS 2008 R2, is there some setting, I've been looking but couldn't

Many Thanks.
Regards Dat.
dat.auduong@sprusons.com.au



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