• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 319
  • Last Modified:

Analysis Manager Permissions Problem - ADOMD

I'm trying to connect to my cube from an ASP page.  I think my permission are wrong or something in Analysis Manager.  Intranet Explorer hangs on this ASP code:
Dim conFoodMart
Set conFoodMart = Server.CreateObject("ADOMD.Catalog")
conFoodMart.ActiveConnection = "Provider=MSOLAP.2;Persist Security Info=True;Data Source=daldw1;Initial Catalog=FoodMart 2000;Client Cache Size=25;Auto Synch Period=10000"

Like I said, I think the problem has something to do with permissions.  I've given all users unrestricted permissions to everything.  Any suggestions?
  • 2
1 Solution
Eugene ZCommented:
did you install latest MSSQL OLAP SP3A?

can you access to DBs with your OLAP manager?
can you try to use Provider=MSOLAP;?
Can you create ODBC DSN  to OLAP and test?

Ensure that you have provided users access to the cubes either via roles (preferred method) or by putting them in the Olap Admins (Windows) user group.

Make sure you know "who" you are when attempting your connection. If you're using EXcel, then you'll be the currently logged on user (note this can be modified via a conxn string setting though! quite neat), but if you're using say asp.net, then if you've not set Integrated Security, then you're most likely connecting as the ASPNET user created by ASP.net/.netframework when installed. This user will need permissions... Or change user.

Lastly, I have seen cases where the catalogs are visible but the cubes aren't - this is often caused by the "visible" property being changed to 'false' - somehow - the users insist they didn't do it, but as yet I haven't seen how the server would do it for them.
INF: How to Connect to Analysis Server 2000 By Using HTTP Connection
AmandaBFAuthor Commented:
I have Analysis Services SP3a.  I can access my dbs with analysis manager.  I tried Provider=MSOLAP - no difference.  I'm not sure how to set up a ODBC connection to my cube.  Could you tell me how to do that?  Where is the visible property located?

Thanks for your help!

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now