How do I create SSIS Catalog using SSMS 2017

How are you trying to create it?  Through the graphical UI or with Powershell statements?

Check out the following MSDN page, it contains both methods about halfway down the page: SSIS Catalog

If through GUI it doesn't work then try using the statements mentioned in the "programmatically" part of the explanation.

Through SSMS 2017.

Hi,

the SSISDB can only be used if the CLR Integration is enabled on your SQL Server.

Your error messages seems like you tried to execute a T-SQL command which needs an already created SSISDB, so to tell anything more you need to describe exactly what you did to get this error.

You could try to enable the CLR Integration manually first and see if there is any problem:
https://www.mssqltips.com/sqlservertip/6104/how-to-enable-sql-server-clr-integration-using-tsql/

You should try to open the folder "Integration Services Catalogs" in SSMS to see if the SSISDB is already there, maybe you do not have the required permissions to see it. As far as I know you need sysadmin rights on the SQL Server to create the SSISDB and to enable CLR integration.

Cheers,

Christian

This is the message I get:

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

The catalog backup file 'C:\Program Files\Microsoft SQL Server\140\DTS\Binn\SSISDBBackup.bak' could not be accessed. Make sure the database file exists, and the SQL Server service account is able to access it. (Microsoft.SqlServer.IntegrationServices.Common.ObjectModel)

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProductVersion=15.0.1301.438&LinkId=20476

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

OK
------------------------------
The creation creation process is looking for a backup file which does not as of yet exists on initial creation.  Where is the script that is trying to create the SSISDB?

Thanks so much for your help.