configure sql 2005 reporting services with firewall and connect to internal database

• Aaron Street

  SSC Veteran

  Points: 230

  More actions

  February 11, 2010 at 2:41 pm

  #216639

  Can someone point to documentation how to configure sql 2005 reporting services with firewall.

  Overview what we are trying.

  Install Report Services Manager on server outside firewall

  Allow outside users to connect to SSRS reports and connect to an internal database?

  Any suggestions appreciated.

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  February 12, 2010 at 9:13 am

  #1118094

  It's basically just what you described... Configure the Report server outside of the firewall, DMZ or something perhaps... Then you just need to make certain you configure your datasources to use the appropriate ports in your connection strings.

  Here's a link from MSDN that covers what you are looking to do.

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

  To help us help you read this[/url]For better help with performance problems please read this[/url]

• Aaron Street

  SSC Veteran

  Points: 230

  More actions

  February 15, 2010 at 6:20 am

  #1118758

  thanks