Link to home
Create AccountLog in
Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Avatar of pepps11976
pepps11976

SSIS will not connect in SSMS (SQL server 2016 13.0.4001.0)
I have installed SQL Server 2016 with  all the features, but when I open the management studio I am unable to connect to SSIS, all other services are availble and the SSIS  service is running. I read an article which suggested using Dcomcnfg.exe to add users to the permission for integration services which i have done. still unable to connect though

User generated image

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Avatar of Vitor MontalvãoVitor Montalvão🇨🇭

Instead of browsing for servers, try to add the SSIS instance manually.
Avatar of pepps11976pepps11976

ASKER

I only used that image as an example, by putting in the servname  I 'm still unable to connect

User generated image
Avatar of Vitor MontalvãoVitor Montalvão🇨🇭

The error it says that SSIS might not been installed. Did you check if the installation was 100% successfully?
Also check if SSIS service is up and running.
Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Avatar of pepps11976pepps11976

ASKER

Yes it is installed and the srvice is running

User generated image
Avatar of Vitor MontalvãoVitor Montalvão🇨🇭

You're using SSMS v17.x, right?

I read somewhere that version of SSMS has issues to connect to SSIS instances of previous versions of SQL Server.
I'll try to find that article but meanwhile you can try to install SSMS v16.5.3 to see if it solves your issue.
ASKER CERTIFIED SOLUTION
Avatar of Vitor MontalvãoVitor Montalvão🇨🇭

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
Avatar of pepps11976pepps11976

ASKER

Hi Vitor,

SSMS 16.5.3 can be downloaded here, it's about 910MB: http://go.microsoft.com/fwlink/?LinkID=840946 

That has worked for me, many thanks
Free T-shirt

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.