MS SQL Server OLAP - Problem in connection to OLAP Database using asp pages

Author

Problem in connection to OLAP Database using asp pages

Shirish Nair

2005-09-29, 7:24 am

Hello,

Using the following code, I am unable to connect to any OLAP database other
than "FoodMart 2000" which comes by default with the Analysis server. I am
using a simple .asp page for the same.
Interestingly the same code works fine when I am connecting through VB
application forms for all the database. There are no users or roles
restriction configured on the OLAP Database.
Has anyone come across this kind of problem.
Please help

Code --
<%
szServer = "10.1.11.111"
szDatabase = "Tutorial"

' create and open ADODB Connection
set C = Server.CreateObject("ADODB.Connection")
C.Provider = "msolap.2"
C.Open "provider=msolap.2;data source=" & szServer & ";user
id=;password=;Connec
t timeout=120;Initial catalog=" & szDatabase
Response.Write ("Connection done succesfully")

%>

Thank you

Shirish

Darren Gosbell

2005-09-29, 8:24 pm

> There are no users or roles

> restriction configured on the OLAP Database.
> Has anyone come across this kind of problem.

When you say there are no restrictions, I assume you mean that the roles
for you database are the same as the role setup in Foodmart that gives
access to everyone.

Have you tried running the VB form application on the server? Your issue
could be a problem with permissions, or it could be a problem with the
olap provider.

Running the VB app on the server should test that the provider on the
server works OK. If it doesn't you might need to look at re-installing
PTS on the server.

--
Regards
Darren Gosbell [MCSD]
< dgosbell_at_yahoo_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell

sefe dery

2005-09-30, 8:24 pm

Shirish Nair schrieb:
> Hello,
>
> Using the following code, I am unable to connect to any OLAP database other
> than "FoodMart 2000" which comes by default with the Analysis server. I am
> using a simple .asp page for the same.
> Interestingly the same code works fine when I am connecting through VB
> application forms for all the database. There are no users or roles
> restriction configured on the OLAP Database.
> Has anyone come across this kind of problem.
> Please help
>
> Code --
> <%
> szServer = "10.1.11.111"
> szDatabase = "Tutorial"
>
> ' create and open ADODB Connection
> set C = Server.CreateObject("ADODB.Connection")
> C.Provider = "msolap.2"
> C.Open "provider=msolap.2;data source=" & szServer & ";user
> id=;password=;Connec
t timeout=120;Initial catalog=" & szDatabase
> Response.Write ("Connection done succesfully")
>
> %>
>
>
> Thank you
>
> Shirish
>

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

Darren Gosbell

2005-09-30, 8:24 pm

>
> 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_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell

Sponsored Links