We are doing Cube Sync between 2 servers. Analysis Service on Both Machines are running under built in Network Service account. When i do cube sync i get following error;
Executing the query ...
Errors in the OLE DB provider. The server returned the following error: (Either the user, DOMAIN\MACHINE$, does not have access to the Country database, or the database does not exist.).
Backup and restore errors: An error occurred while synchronizing the 'Country' database.
Does SSAS Sync supports using Network Service Account?
If Yes then how do i do this. I tried creating a role in SSAS database and Give Full Rights to Network Service account of source server but i keep getting error DOMAIN\MachineName$ not found.
View Complete Post