Making SSRS its own web site

Question

Making SSRS its own web site

pveilleux

Ten Centuries

Points: 1363
More actions
July 7, 2011 at 2:04 pm

#253406

hello, everyone....
I was spending time today setting up our new production servers and I came across something I wasn't aware of, mostly because we're doing something we didn't do in our development environment.
We have an SSRS 2008 R2 box that will house SSRS and MDS. Reason for this is I thought SSRS still required IIS in 2008 R2 (shame on me), and I figured let's put all these SQL web apps on one machine. In development, for MDS, I just specified a different port to make it work. For production, I don't want the users to have to type in "http://server/reports" to get to their page. I only want them to have to remember "http://reports". Much easier for them. Likewise, with MDS, we are going to have "http://mds", but since this is handled via IIS, I think I can handle that.
So, my question to all of you is, can I make this happen within SSRS Config Manager or is this something better handled within DNS? I couldn't find anything in my searches about this and I feel like I've tried a variety of terms/phrases. I'm still waiting for a new IP to be added to the server. I wanted to post this, see if anyone can chime in, so I'll know whether or not we should bother with that new IP.
thanks....
Peter

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 1

For a production environment and depending on the reports and its users I would suggest using the Report viewer control in VS and creating a page to point to the reports. There is too much information available on the default URL and this could be confusing for business users also at some point if you want to have forms authentications and LDAP then the ASP.net page is the way to go.

Jayanth Kurup[/url]

steveb. SSC-Forever Points: 46733 More actions · Answer 2

you could always install IIS on the box as well and do the redirect there

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/86932bb5-a721-47ff-8ed0-1e144c87be4d

pveilleux Ten Centuries Points: 1363 More actions · Answer 3

steveb. (7/7/2011)
you could always install IIS on the box as well and do the redirect there
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/86932bb5-a721-47ff-8ed0-1e144c87be4d

Since IIS is already installed for Master Data Services, this looks like it might be a good option, won't require any coding and will allow us to really customize the home page. I'll look into this one some more.

Thanks, Steve....