Install SQL Reporting Services to Second SQL Instance

When you install a second SQL Reporting Services instance, it will place the databases in the default SQL instance by default. This happens even if both SQL instances are named instances. To place the second SQL Reporting Services databases in the correct SQL instance, you must do the following. [more]

  1. Open SQL Reporting Services Configuration Manager
  2. Select the Report Server you want to manage
  3. Click the Databases tab > Change Database
  4. Choose Create a new report server database
  5. Enter the server name and SQL instance where you want the SQL Reporting Services databases installed
  6. Take the defaults through the rest of the install and enter credentials as needed
  7. Install your application and point it to the second SQL instance where you just setup the new SQL Reporting Services instance.

Networking SQL SQL Reporting Services