SSISDB Integration Services Catalog

Parameters in SSIS.   In the past for SSIS we used the XML files.   We pointed to these by setting up a system variable. 

I used Integration Services Catalog because of security issues we had across two servers.   This process no longer used the System varibles and XML files.

I right click on:

Integration Service Catalog-My container name-projects-Packages container-my package container name-Packages-Name Of my DTSX

I choose Configure, a box opens.  There are two tabs in the center of the box.

1. Parameters
2.  Connection Manager

I choose connection manager.   There were 2 boxes.

1. Container Name
2. Properties

I modified the values one at a time by hitting the (...) the right of each one.   I copied the value from the use default value from Package.   I click on the "Edit Value", replace the corrected string
I hit ok to save these values twice. 

Now my SSIS was pointing at the correct server!

SQL SSISDB configuration

TITLE: Microsoft SQL Server Management Studio
------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Management.IntegrationServices)

------------------------------
ADDITIONAL INFORMATION:

String or binary data would be truncated.
Invalid object name 'sys.trusted_assemblies'. (Microsoft SQL Server, Error: 8152)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=12.00.4100&EvtSrc=MSSQLServer&EvtID=8152&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Google or bing returned nothing of value.

I tried to create the Catalog in Sql service manager, from a remote computer.   I logged onto the server SQL was running on.   I ran it as Administrator.  I ran the same version of Sql server manager as the data base.   In this case 2012.   the version I tried remote was 2014.   This allowed me to create the SSISDB for SSIS.