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