Report Server Web service on public IP

  • Hi All,

    Is there any possibilities to have sql server on one IP which is not public due to security reasons and Report Server Web service on another IP which is public to access the deployed reports on SSRS.

    If it is possible please let me know the process of hosting Report Server Web service on public IP which can access data from sql server database which is on another IP (Private).

    Please help me regarding this.

    Pradeep K.

  • Install SQL server on the internal machine.

    Then put the CD into the public IP address machine, and install just the Reporting Services component. During installation it will ask you for the address of the 1st machine to store the reporting services database.

    Then you will need to work out your authentication requirements.

    Note: When you put SQL Server and Reporting Services on different machines, it can create a (legal) licensing issue.

  • Thank you:-)

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

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