none
SQL Server NLB and SSL RRS feed

  • Question

  • Dears,

    I am doing some expriements with SSRS, the setup is I have SQL Server cluster (Active-Passive, 2 nodes), Two SQL Server Reporting Service (NLB)

    I want to enable the NLB and SSL

    I will use makecert to generate the certificate, I have to http://ssrs1/reportserver, http://ssrs2/reportserver, nlb url is http://ssrs/reportserver

    the quesiton is should I generate SSL Server certificate (self-signed) using cn=ssrs or two certificates (cn=ssrs1,ssrs2)

    secondly, is there is a difference between using FQN and short servername in the report server configuration files?

    btw, I tried both and neither works for me, but want to make sure which one is the right direction to continue my troubleshooting.


    Tareq Ali ITWorx Arabia Technical Consultant
    Friday, December 9, 2011 8:42 AM

All replies

  • Hi Tareq Ali –ITWorx,

    Thanks for the question. As we know, Reporting Services itself is not cluster aware. To increase the performance and haleness of Reporting Services, we install the reportserver database on a clustered instance of SQL, or deploy the Reporting Services in scale-out mode. Adam has one article describes the detail information about using Reporting Services in cluster, I would recommend you reference it:

    Reporting Services, Scale Out and Clusters…

    Best Regards,
    Sharp Wang


    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contact us.

     


    Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
    Monday, December 12, 2011 3:26 AM
    Moderator
  • Thanks Sharp for your answers, but this doesn't cover the SSL Settings for the SSRS.

    "the quesiton is should I generate SSL Server certificate (self-signed) using cn=ssrs or two certificates (cn=ssrs1,ssrs2)

    secondly, is there is a difference between using FQN and short servername in the report server configuration files?

    btw, I tried both and neither works for me, but want to make sure which one is the right direction to continue my troubleshooting."


    Tareq Ali ITWorx Arabia Technical Consultant
    Monday, December 12, 2011 3:54 AM
  • Hi Tareq Ali,

     

    For the SSL certificate generation use the NLB virtual name.

     

    I am not sure which setting you exactly mean with the second question.

    If you speak of the URLReservations setting then you should never modify the values directly. (http://technet.microsoft.com/en-us/library/ms345223.aspx)

    If you mean the url then it should use the name as defined in the certificate.

     

    There are some differences between 2005 and 2008. Here some links that discuss this topic:

     “Using SSL Offloading” and “Edit UrlRoot in the RSReportServer.config File”  sections of Configuring a Report Server for Secure Sockets Layer (SSL) Connections

    http://msdn.microsoft.com/en-us/library/ms345223(v=SQL.90).aspx

    How to configure SQL Server 2008 R2 Reporting Services for SSL offloading

    http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/8648d2e1-36ed-40a7-b471-957464966735

    URLs in Configuration Files (Reporting Services)

    http://msdn.microsoft.com/en-us/library/bb630431.aspx

     

     

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

     

    Thanks,

    Orsi

    Microsoft Online Community Support

     

    Monday, January 23, 2012 10:19 AM
    Answerer