MS SQL Data Warehousing - Database Synchronization IN Analysis Services 2005

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Database Synchronization IN Analysis Services 2005

somuthomas@gmail.com

2006-10-25, 6:00 am

Hi,

I am getting errors while synchronizing databases between two machines
in my LAN using the SQL server 2005 Management Studio - analysis
services' synchronize option. After the XMLA script generated by
deployment wizard from my cube was executed successfully. I kept my
system as the Development server and the other system as the Production
server. Then in the Production server's SQL server 2005 Management
Studio - analysis services' synchronize option I gave source server
name as mine and source database as the cube filename. Then executed
the synchronize command and the errors appeared ("peer prematurely
closed the connection"; "error was encountered in the transport
layer"). What is the reason for this??

Thanks,
Somu

Sponsored Links