Connecting from SQL 2008 SSMS to SQL 2005 SSIS

#1

I am not able to connect to SQL 2005 SSIS from SQL 2008 SSMS. I get following
error.

Connect to SSIS service on machine xxxxx failed "class not registered"

How come I am getting this error? I have 2008 server and 2005 client tools
on my machine.

Thanks,
Prabhu

#2

Prabhu wrote:

Quote:

I am not able to connect to SQL 2005 SSIS from SQL 2008 SSMS. I get following
error.

Connect to SSIS service on machine xxxxx failed "class not registered"

Yeah, this is annoying, but that's the way it is.

https://connect.microsoft.com/SQLSer...dbackID=363922

In short: you'll need 2005 SSMS to connect to 2005 SSIS. Even Microsoft
doesn't always get backwards compatibility right.

--
J.

#3

This is really frustrating. MS came up with SQL 2008 pretty fast and not
having client tools backward compatibility is really awful.

"Jeroen Mostert" wrote:

Quote:

Prabhu wrote:
I am not able to connect to SQL 2005 SSIS from SQL 2008 SSMS. I get following
error.

Connect to SSIS service on machine xxxxx failed "class not registered"

Yeah, this is annoying, but that's the way it is.
https://connect.microsoft.com/SQLSer...dbackID=363922

In short: you'll need 2005 SSMS to connect to 2005 SSIS. Even Microsoft
doesn't always get backwards compatibility right.

--
J.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Connecting from SQL 2008 SSMS to SQL 2005 SSIS

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Connecting from SQL 2008 SSMS to SQL 2005 SSIS - 09-14-2009 , 05:34 PM

Re: Connecting from SQL 2008 SSMS to SQL 2005 SSIS - 09-14-2009 , 11:59 PM

Re: Connecting from SQL 2008 SSMS to SQL 2005 SSIS - 09-15-2009 , 12:46 PM