From the course: SQL Server Integration Services

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Connect to the SSIS catalog database

Connect to the SSIS catalog database - SQL Server Tutorial

From the course: SQL Server Integration Services

Start my 1-month free trial

Connect to the SSIS catalog database

- As with other SQL Server services, you'll use configuration manager to verify that integration services is running on your computer. You can find it in a folder on your start menu underneath the Microsoft SQL Server folder and it's right here. SQL Server 2019 and I'm using the CTP 3.0 version and its configuration manager. Let's go ahead and choose that application, allow it to make changes to my computer. And then if you click on SQL Server services over in the left hand window, you'll see a list of all your different services, including integration services. You can see that my installation is currently running and it's set to the start mode of automatic, just like my database engine. To get additional details, you can double click on the service and that'll bring up the properties window. Here you can start, stop, pause and restart the service. And you can also use the buttons here on the toolbar to do the same. So mine is currently running which is great. Let's go ahead and…

Contents