I am trying to synchronize two databases and getting the below error. I am using Microsoft SQL Server Management Studio 2008 to sync the two databases. One of the databases is running Analysis
Services 2008SP1 (the source) and the other is running Analysis Services 2008R2 (the destination). I have tried the
Microsoft SQL Server 2005 Backward Compatibility tool and that did not work. My thought is that the different versions are causing a conflict. The surprising thing
is that it appears to be working and then fails. Keep in mind I am using an administrator account. Can someone please advise?
Errors in the OLE DB provider. The server returned the following
View Complete Post