Post reply

New to SSRS and how most people implement (on its' own server or with db engine)

  • June 24, 2014 at 6:47 am

    #295890

    Hi

    I have implemented SSRS on one of our test servers that also has the database engine installed. This is the first time our company is going to use SSRS. What I would like some input on is: Should SSRS be on its own server for production and if not how do you handle all the http (ie do you have Report Services installed on all your servers? Do each of these server have a separate http?) Any input on how you implement Report Services would be helpful.

    Thanks

  • July 9, 2014 at 3:15 pm

    #1728223

    kathy.plamann (6/24/2014)

    Hi

    I have implemented SSRS on one of our test servers that also has the database engine installed. This is the first time our company is going to use SSRS. What I would like some input on is: Should SSRS be on its own server for production and if not how do you handle all the http (ie do you have Report Services installed on all your servers? Do each of these server have a separate http?) Any input on how you implement Report Services would be helpful.

    Thanks

    Kathy,

    Your answers will be "It depends". We have clients with many different environments. Rarely do we see a stand-alone SSRS server. We see mainly native SSRS environments - meaning not SharePoint integrated. Most of the SSRS installs are done with other SQL components like the DE.

    The http of SSRS is typically the server name followed by \Reports which is where the Report Manager root is located. From there you can create folders and sub-folders and assign security as needed. Users can browse the SSRS folder structure to get to their reports, or you can link to the folders or reports from your application. Separate SSRS servers will have different http references.

    Note too that you can and should use a certificate if you plan to expose those reports outside your firewall. In that case you will address an https instead. You can also do this for internal reporting if security is a concern.

    I'd encourage you to read up on SSRS in MSDN or Books Online as there is some very helpful information there.

Viewing 2 posts - 1 through 1 (of 1 total)

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