unable to connect analysis service database

Copper Contributor

hi ..

i am connected to analysis service database like this 

BakhtawarA_1-1710223687436.png

 

after connecting i create new empty database .. then i restore adventure.abf database into adve empty database by click right ---- restore database

 

BakhtawarA_2-1710223774041.png

 

by clicking ok i got an error 

 

 

BakhtawarA_0-1710223650286.png

 

so after searching i grant permission .. and create new role DBAdmin and give all rights

BakhtawarA_3-1710223905375.png

 

BakhtawarA_4-1710223939004.png

 

still no success.. 

 

how to resolve this issue

 

help needed

2 Replies

@Bakhtawar A. 

 

In your second screenshot, did you remember to place a checkmark in the "Allow database overwrite" checkbox?

 

Cheers,

Lain

no i did not.. and for test purpose . . i also check marked.. but still same error