SQL Server Performance


Discussion in 'SQL Server 2005 Reporting Services' started by patdev00, Sep 28, 2007.

  1. patdev00 New Member

    Hi all,
    Would any please guide me to get SSRS set up on DMZ server please. What are the steps i need to aware of? How will the process work will be same as regular SSRS installation? also what prot or ports i have to open on the firewall side!!
  2. satya Moderator

    You may be aware that SQL Server uses TCP port 1433 and UDP port 1434, in thsi case you have to consider the Browser service too for security and for this refer to the Books online for setting up the services.
    Also you have to to make it secure without password tokens will be using secured certificates point-to-point or many-to-one, if you are using any for the VPN to encapsulate all traffic between web server and SQL server. For further information on DMZ take a look at the http://blogs.msdn.com/tudortr/archive/2005/11/03/488731.aspx blog.

Share This Page