Monday, March 19, 2012

Connection issue with Management Console

When i try to connect to Integration Services on a SQL 2005 Machine, it Gives me a Class not registeed.

But i can connect to SQL 2008 Integration Services without a issue.

I tried Restarting the 2008 machine and Also Reinstalling the SSIS Piece and also Reinstalled SQL 2008, but nothing seems to Help.

Could you provide more details? Do you have SQL 2005 and SQL 2008 installed on the same machine?

Thanks,

Bob

|||

No, I dont

I Just Have SQL 2008 July CTP installed on a Windows Xp SP2 MAchine and I try to connect to another SQL Server 2005 Server (Integration Services)

I am Even Having Trouble opening the Maintenance Plan in SQL 2008.

|||

Hi there,

In the July CTP you can not connect to a 2005 SSIS service through 2008 Management Studio. To manage a 2005 SSIS service, you'll need to use the 2005 version of SSMS.

We're currently investigating ways to resolve this issue, but it's unclear whether we'll be able to solve this for the 2008 release.

~Matt

No comments:

Post a Comment