class not registered/ Access denied
Hi, I have SQL server 2005 Client on Windows server 2003 server edition. And SQL Server 2008 R2 and SSIS installed on 2 different Windows server 2008 R2. When I try to connect from the Management Studio of SQL Server 2005 to the Integration Service of SQL Server 2008 R2, I receive different error in both the servers. I tried with this link "http://msdn.microsoft.com/en-us/library/aa337083(v=sql.105).aspx", but unable to resolve it. in one I get TITLE: Connect to Server ------------------------------ Cannot connect to XXXX. ------------------------------ ADDITIONAL INFORMATION: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ Connect to SSIS Service on machine "XXXX" failed: Class not registered . ------------------------------ Connect to SSIS Service on machine "XXXX" failed: Class not registered in another I get TITLE: Connect to Server ------------------------------ Cannot connect to YYY. ------------------------------ ADDITIONAL INFORMATION: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ Connect to SSIS Service on machine "YYY" failed: Access is denied. . ------------------------------ Connect to SSIS Service on machine "YYY" failed: Access is denied. . Both the server built are identitical, Not sure why I am receiving different error. Please suggest how to proceed. Thanks Dharmbir
February 1st, 2013 9:43am

You can't connect to a 2008 SSIS instance with the 2005 tools.Chuck Pedretti | Magenic North Region | magenic.com
Free Windows Admin Tool Kit Click here and download it now
February 1st, 2013 9:50am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics