Geek Answers Handbook

Unable to connect to analysis services through excel

I have service analysis cubes in SQL Server 2005 that I connect with through the excel interface.

When I connect its fine through one user, but when I log on to the same computer as another user, I get an error message in my excel spreadset - "user ... does not have access to the database [Cube name]

Obviously, the first user has the correct permissions, but how to configure the analysis services so that other users can join this side?

+5
source share
4 answers

Log in with the account that is the administrator (Domain \ CubeAdmin) on the cube. Connect to the cube in BIDS (run devenv.exe and open the Analysis Services database).

In the Roles section, create a reader role, and on the Membership tab, add a user account (Domain \ NewUser).

All this will work only if the SSAS server administrator grants \ NewUser domain access to the server.

+3
source

The Windows user accounts that you are trying to access SQL Analysis Services should be added to roles in the cube that allow you to allow.

HTTP msmdpump.dll IIS, Windows .

IIS msmdpump , , .

+1

, , MS Office, SSAS. , " ".

0

Raj ... , , , SSAS.

" " , . Excel 2007 , , Excel.

, , ( ):

  • - ( auth)

  • ADOMD OLEDB Analysis Services ( )

  • , SSAS, ( ApplicationPoolIdentity?)

  • (script mapping *.dll)

HTTP- SSAS: Microsoft - HTTP- SSAS IIS

0
source

More articles:


All Articles