February 13, 2012 at 9:59 pm
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.comFebruary 14, 2012 at 1:37 am
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:
February 14, 2012 at 3:25 am
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).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 14, 2012 at 3:47 am
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.
February 14, 2012 at 4:01 am
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 14, 2012 at 4:04 am
very good article, easy understanding of explanation!!!
thanks!
February 14, 2012 at 8:15 am
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.
February 14, 2012 at 8:27 am
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.
February 14, 2012 at 8:53 am
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.
February 16, 2012 at 2:02 pm
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.
February 16, 2012 at 2:09 pm
dati (2/16/2012)
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.
Hi Dati,
I don't understand your question. Can you explain your question?
Basit
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comFebruary 16, 2012 at 2:10 pm
dati (2/16/2012)
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.
Hi Dati,
I don't understand your question. Can you explain your question?
Basit
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comFebruary 20, 2012 at 8:55 am
If I want to use Reporting Services almost exclusivley for displaying data from an Oracle database, what is the minimum Microsoft Licences I require for this installation?
Regards
Phil Hull
February 20, 2012 at 8:58 am
I think it would be 1 processor license or 1 CAL per user.
It doesn't matter how much of SQL Server you install as long as it's all 1 instance.
February 20, 2012 at 9:14 am
Peter
Thanks for your very prompt reply , this is not as daft as it sounds as we have a product that works both on SQL Server and Oracle and I am looking for common reporting servces.
Phil
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply