March 30, 2016 at 11:49 am
Hi,
Unable to connect to Integration Services from my local system. Getting this error. SQL Server Version is 2008 R2 (10.50.4042.0)
TITLE: Connect to Server
------------------------------
Cannot connect to .......
------------------------------
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 "....." 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=220763
------------------------------
Connecting to the Integration Services service on the computer "....." 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:
OK
------------------------------
Thanks.
March 30, 2016 at 1:04 pm
Presuming you're connecting with SSMS, you're probably not using the same version of SSMS as the SQL Server SSIS.
IE, you're using SSMS from SQL2012, the SSIS is SQL2008.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply