SSAS Synchronisation issue

Question

SSAS Synchronisation issue

LittleKitten

Say Hey Kid

Points: 666
More actions
September 21, 2017 at 2:11 am

#151529

Hi,
I am trying to synchronise a SSAS database on live with dev.
I get the message
'Errors in the OLE DB provider. The server returned the following error.
EIther the user [[ServerName$]] does not have access to the database or the database does not exist.
I'm pretty sure the permissions are ok on both source and target servers so am stuck!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Brian Carlson SSCarpal Tunnel Points: 4170 More actions · Answer 1

It sounds like a permissions issue in your source. When you deploy it you need to give the account that you've used permissions in the SQL Server database. This is often the SSAS service account, but you can also set up credentials in the source. If this doesn't answer your question, please give more information as I'm not sure what else you could mean by "synchronise a SSAS database".

-Brian

LittleKitten Say Hey Kid Points: 666 More actions · Answer 2

Hi Brian,
I'm not deploying/processing a database.(I can do that)
What I have is a Live and Dev environment and instead of deploying the solution again to DEV I want to syncronise the database from LIVE
If you right click databases you get an option to synchronise. This is what I am trying to do.
It is a permissions issue, but I'm not sure what user I need to add to LIVE/DEV to get synchronisation to work.

Thanks

Ant-Green SSC Guru Points: 113507 More actions · Answer 3

Have you gone through the following article?

https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/synchronize-analysis-services-databases

Are you running Enterprise edition in Prod and Dev?

LittleKitten Say Hey Kid Points: 666 More actions · Answer 4

Hi Anthony,

Yes I have gone through that and I am happy I have satisfied the pre-requiesites.

And yes, DEV and LIVE are both enterprise editions.

Brian Carlson SSCarpal Tunnel Points: 4170 More actions · Answer 5

In SQL Server, you can use SQL Profiler to determine what the failed permissions are. I think it's "User Error" event but not sure off the top of my head. There may be a similar event for SSAS.