1

We are in the process of migrating our dbs from SQL 2016 to SQL 2019. I was having issues restoring the SSISDB on a dev server so decided to start fresh and deploy packages on new server instead. I deleted SSISDB, cleaned up job, and restarted services. I don't have the option to Create the Catalog now. Any ideas?

enter image description here

EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'SSISDB'
GO
USE [master]
GO
/****** Object:  Database [SSISDB]    Script Date: 3/27/2023 1:35:55 PM ******/
DROP DATABASE [SSISDB]
GO
USE [msdb]
GO

/****** Object:  Job [SSIS Server Maintenance Job]    Script Date: 3/27/2023 1:45:30 PM ******/
EXEC msdb.dbo.sp_delete_job @job_id=N'b5d21d88-2f64-4474-ac44-9c0cad5f9173', @delete_unused_schedule=1
GO

1 Answer 1

1

It can be that SSIS is not installed.

You can launch SQL Server Discovery Report – Determining what SQL Server Components are Installed

Location on the hard drive: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2017\Configuration Tools

Good link on the subject: sql-server-2012-discovery-report-determining-what-sql-server-components-are-installed

https://learn.microsoft.com/en-us/answers/questions/287350/create-catalog-is-greyed-out-in-ssis

2
  • Aha! It appears it was not setup correctly. Thank you Peter!
    – irishgirl
    Mar 28, 2023 at 13:35
  • Welcome, don't forget to mark the Answer as answered so people know it is verified :)
    – Peter
    Mar 28, 2023 at 17:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.