SSDT server setup and using 3rd party tools across servers

• frederico_fonseca

  SSCoach

  Points: 16279

  More actions

  January 24, 2020 at 6:13 pm

  #3720252

  you can't.

  SSIS Catalog packages execute on the server where the catalog is installed so your setup needs to be

  Server A

  - SQL Server Instance

  - - User databases

  - - ReportServer db's - (optional but not advisable)

  Server B

  - SQL Server instance

  - - SSIS Catalog

  - - ReportServer db's - (optional if you choose to install its db on the application server - not advisable)

  - SSIS Integration Services (required to create SSIS Catalog and to allow execution of DTS Packages from the command line

  - SSAS instance

  - SSRS Instance

  - - ponting to either ReportServer db's on Server B or Server A (Not advisable)

• Phil Parkin

  SSC Guru

  Points: 247183

  More actions

  January 24, 2020 at 6:53 pm

  #3720263

  Frederico is spot on.

  In addition, note that SSDT is a client tool and should, therefore, not be installed on either of your servers.

  • This reply was modified 5 years, 9 months ago by Phil Parkin. Reason: Fix typo

  ---

• dmusson17

  Ten Centuries

  Points: 1235

  More actions

  January 24, 2020 at 7:07 pm

  #3720267

  Thanks guys.  All makes sense.