Connecting to the Integration Services service on the computer "WIN-5U5BLQJ45G3" failed with the following error: "Class not registered".

Question

I follow the tutorial for SQL Server 2019 Standard Edition at

https://learn.microsoft.com/en-us/sql/integration-services/lesson-3-3-testing-the-deployed-packages?view=sql-server-ver15

However, I received the error below while connecting to the Integration Service using SQL Server Management Studio v19.2.

Answer 1

Hi @Nur Izzati Binti Rosli，

Please first make sure that you have installed SSIS service successfully.

Secondly please run SSMS as administrator and then connect to SSIS for a try.

In addition, you may use SSISDB catalog which is the central point for working with Integration Services (SSIS) projects that you've deployed to the Integration Services server.

See Understanding the SQL Server Integration Services Catalog and creating the SSISDB Catalog

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Have you installed SSIS at all on the server/machine? It's an optional feature and by default during installation not selected.

And if you have installed the free SQL Server Express Edition, that don't support SSIS.

Answer 3

Hi @Nur Izzati Binti Rosli，

It is highly suggested to use the SSMS version match with SQL Server version.

Please try to install SSMS v18.x.

https://sqlserverbuilds.blogspot.com/2018/01/sql-server-management-studio-ssms.html