Re: Problem in connection to OLAP Database using asp pages
- From: Darren Gosbell <xxx@xxxxxxx>
- Date: Sat, 1 Oct 2005 08:03:20 +1000
>
> I think you have a permission problem.
> you should :
> 1.)right click to your cube -->manage roles
> 2.)new
> 3.)rolename: role_everyone
> 4.)ADD:everybody(all users)
> 5.)cubes: check all
> 6.)thats all
>
> if this doesnt work for your cube then there are another problem.
>
> best regards
> Sefer
>
Just adding some extra info on security with Web Applications...
Typically, with ASP/ASP.NET applications, the user either:
1) IUSR_<machine name> for traditional ASP
2) ASPNET for ASP.NET apps on IIS 5 and below
3) NETWORK SERVICE for ASP.NET on IIS6 (Win 2003)
None of these are not usually in the Everyone group and have to be added
to the Analysis Services Roles as individual users.
(Of course it is also possible to override the default user and put an a
domain user, but this does decrease the overall security of the web
server)
However Shirish said that he could access Foodmart and I am assuming
that he has set up the roles the same in both databases. This leads me
to believe that he may have a problem with his Olap provider setup on
the web server. You can access Foodmart with both the v7 driver and the
v8 driver, typically databases that are created from scratch in AS2k can
only be access using the v8 driver. (I think this may be because
Foodmart was migrated from Olap Service 7.0)
--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell
.
- Prev by Date: Problem with Analysis Services 2005
- Next by Date: RE: Difficult MDX-Statement
- Previous by thread: Problem with Analysis Services 2005
- Next by thread: RE: Difficult MDX-Statement
- Index(es):
Relevant Pages
|
