Thursday, July 25, 2013

When perform CUBE sync , error pops up

Similar to below:

 

Database synchronization started.

The physical TCP/IP connection failed: An existing connection was forcibly closed by the remote host. 

The peer prematurely closed the connection.

Backup and restore errors: An error occurred while synchronizing the 'AdventureWorks' database.

An error was encountered in the transport layer.

Database synchronization failed.

 

 

Solution:

 

  • Logon to SSAS "Destination server" (i.e. the destination server on which you want to Synchronize SSAS database from source server).
  • Open "Computer Management" (you can open "Computer Management" simply by typing shortcut "compmgmt.msc" in the "Run" window).
  • Under "Computer Management", expand "Services and Applications" node and then select "Services" node. 
  • Under Services panel, right click on "SQL Server Analysis Services(MSSQLSERVER)" and select Properties.
  • Under Properties window, click on "Log On" tab and select option "This account" instead of "Local System account". Mention the credentials of the active directory user who has admin rights (i.e username and password) and restart the services.

 

http://aniruddhathengadi.blogspot.ca/2011/09/error-while-synchronizing-ssas-database.html

No comments:

Post a Comment