access centralized SSISDB - SQL Server 2016

• henriks

  Newbie

  Points: 4

  More actions

  November 27, 2018 at 8:05 am

  #376487

  Hello,

  i have to build an SSIS in an Availabilty Group Environment. i have 4 SQL Server Standard 2016 Licences for the 4 servers.
  I have build two servers in an HA Group. Create my work databases and the SSISDB on both DB Server. 
  Yes this mean mean i have installed Integration services on the DB Server. 

  Then i installed SSIS on the both Servers that i want to use for ssis.

  This gives the following configuration:

  • Server 1 - SQL-SRV1

  • SQL Server
  • SSIS 

• Server 2 - SQL-SRV2

• SQL Server 
• SSIS 

• Server 3 - IS-SRV

• SSIS

• Server 4 - IS-SRV

• SSIS

I connect server 3 and 4 with the centralized environment but i don't see the SSISDB. I only see the msdb.
Yes i edit my msdtssrvr.ini. And yes the Inte

<?xml version="1.0" encoding="UTF-8"?>
<DtsServiceConfiguration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>
<TopLevelFolders>
    <Folder xsi:type="SqlServerFolder">
           <Name>SSISDB</Name>
           <ServerName>SQL-SRV</ServerName>
    </Folder>
<Folder xsi:type="FileSystemFolder">
             <Name>File System</Name>
              <StorePath>..\Packages</StorePath>
</Folder></TopLevelFolders>
</DtsServiceConfiguration>

My Problem is: I don't see the SSISDB in SSMS in the integration services. How to fix this?