I'm trying to connect to Integrations services for the first time, I am using SSMS 2017, and my SQL Server is SQL Server Developer 2017.
Both are on 2017, but I get the following error, does anyone know how to get around this issue? Thanks in advance.
TITLE: Connect to Server
Cannot connect to DESKTOP-9V8LFD7.
ADDITIONAL INFORMATION:
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476
Connecting to the Integration Services service on the computer "DESKTOP-9V8LFD7" failed with the following error: "Class not registered".
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
Connecting to the Integration Services service on the computer "DESKTOP-9V8LFD7" failed with the following error: "Class not registered".
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:
