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 - SQL Server Tutorial
From the course: SQL Server Integration Services
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.