all groups > sql server reporting services > october 2006 >
You're in the

sql server reporting services

group:

Database Synchronization IN Analysis Services 2005


Database Synchronization IN Analysis Services 2005 somuthomas NO[at]SPAM gmail.com
10/10/2006 10:32:49 PM
sql server reporting services: 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
Re: Database Synchronization IN Analysis Services 2005 aaron.kempf NO[at]SPAM gmail.com
10/11/2006 11:28:51 AM
have you tried doing this by IP instead of by name?

do these machines have static IPs?

-Aaron


[quoted text, click to view]
Re: Database Synchronization IN Analysis Services 2005 somuthomas NO[at]SPAM gmail.com
10/11/2006 10:52:17 PM
Hi,

i used IP where the SSMS synchronise service asked for server name but
the same error shows up... Is there any specific set of error
possiblities that i should check before i do the
synchronization?????????

Thanks,
Somu
Re: Database Synchronization IN Analysis Services 2005 aaron.kempf NO[at]SPAM gmail.com
10/11/2006 11:08:10 PM
are you using like.. SP0 drivers against a SP1 server?

just trying out ideas here man



[quoted text, click to view]
Re: Database Synchronization IN Analysis Services 2005 somuthomas NO[at]SPAM gmail.com
10/11/2006 11:18:55 PM
Hi,

I understand..But I installed the from the same cd on the both
machines, so i dnot think there would a SP problem.... If it is what u
say it is, how do i check it out???

Thanks,
Somu
AddThis Social Bookmark Button