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

do you have any firewall between the servers?
can you access the dev server from the prod server using the management
console?

<somuthomas (AT) gmail (DOT) com> wrote

Hi,

Yes i can access dev server from the prod server using the management
console.. when i tried to run batch execute for XMLA it showed the
error "OLE DB error Invalid authorization specification 28000" i hope
this info could be of some help to u...

Thanks,
Somu

what is the account used to run the SSAS service?
do you use a domwain account?
maybe your Prod account has no access to the dev server

if you use the local system or network service account, try to change it to
a domain account.

<somuthomas (AT) gmail (DOT) com> wrote