1

Please see below. We have SSIS services installed and running, but it appears we cannot connect to them.

What is the path to get them set up and working?

TITLE: SSIS Execution Properties
------------------------------
Connecting to the Integration Services service on the computer "886319-DB1C" failed with the following error: "The specified service does not exist as an installed service.".
This error can occur when you try to connect to a SQL Server 2005 Integration Services service from the current version of the SQL Server tools. Instead, add folders to the service configuration file to let the local Integration Services service manage packages on the SQL Server 2005 instance.
For help, click: http://go.microsoft.com/fwlink/?LinkId=506689
------------------------------
ADDITIONAL INFORMATION:
Connecting to the Integration Services service on the computer "886319-DB1C" failed with the following error: "The specified service does not exist as an installed service.".
This error can occur when you try to connect to a SQL Server 2005 Integration Services service from the current version of the SQL Server tools. Instead, add folders to the service configuration file to let the local Integration Services service manage packages on the SQL Server 2005 instance.
------------------------------
BUTTONS:
OK
------------------------------

enter image description here

asked Apr 13, 2018 at 1:27

1 Answer 1

2

Solved.

I was using SSMS 17.1 against SQL Server 2016.

SSMS 17 works great w SQL Server 2016.... except it cannot connect to SQL 2016 SSIS. To connect to SQL 2016 SSIS, you must use SSMS 16.x

Installed SSMS 2016, (v16.x), and it connects fine to Integration Services.

answered Apr 13, 2018 at 15:39
2
  • Pretty true for all SSIS versions... It's always recommended to use the respective SSMS version to connect to them. Main reason I have 4 versions of SSMS on my machine! Commented Apr 13, 2018 at 19:33
  • @GarethLyons Yup. I am new to SSIS, so had not hit this before. I have always been a "one version of ssms" guy (managing at least 3 vers of sql server), but am now a multi-ssms guy..... ack! Commented Apr 13, 2018 at 21:45

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.