Internet User can not connect to MSOLAP

Internet User can not connect to MSOLAP

Post by Shahab Geram » Thu, 29 May 2003 01:11:32



Hi

The IIS is running 2000 Server and OLAP is running on NT 4.0.   I set the
Directory Security on the folder for the IUSR_Server . The IUSER_Server has
access to the NT 4.0 which is running MSOLAP, But the users connecting frm
internet can not connect to the olap.
Is there any tracing or logging that I can do on Analysis Server that would
tell me what is the use name and password IIS is passing?
thanks

 
 
 

Internet User can not connect to MSOLAP

Post by mdh33 » Thu, 29 May 2003 03:19:58


What did you give the IUSR account access to?  You need to set it up as
a role in one of the cubes if you have any security setup?

You can test this by giving EVERYONE access to the cube and seeing if
this works.

--
Posted via http://dbforums.com

 
 
 

Internet User can not connect to MSOLAP

Post by Shahab Geram » Thu, 29 May 2003 03:55:06


Yes EVERYONE  has access to the cube and IUSR is in  olapAdmin group
I tested this account with login to a pc and access OLAP from Excel, and it
works fine. But it does not get the access from internet.


Quote:

> What did you give the IUSR account access to?  You need to set it up as
> a role in one of the cubes if you have any security setup?

> You can test this by giving EVERYONE access to the cube and seeing if
> this works.

> --
> Posted via http://dbforums.com

 
 
 

Internet User can not connect to MSOLAP

Post by Patrice Lamarch » Thu, 29 May 2003 21:35:53


Hello Shahab,
    I would like to know what application you use to connect to the cube
from internet ? a webcomponent .. excel .. third party.. asp page?

Thanks

Patrice

> Yes EVERYONE  has access to the cube and IUSR is in  olapAdmin group
> I tested this account with login to a pc and access OLAP from Excel, and
it
> works fine. But it does not get the access from internet.



> > What did you give the IUSR account access to?  You need to set it up as
> > a role in one of the cubes if you have any security setup?

> > You can test this by giving EVERYONE access to the cube and seeing if
> > this works.

> > --
> > Posted via http://dbforums.com

 
 
 

Internet User can not connect to MSOLAP

Post by Shahab Geram » Fri, 30 May 2003 21:05:12


Patrice,
there are Microsoft Office Web Component that you can use. But the use has
to have the IE 5.5 or higher



> Hello Shahab,
>     I would like to know what application you use to connect to the cube
> from internet ? a webcomponent .. excel .. third party.. asp page?

> Thanks

> Patrice


> > Yes EVERYONE  has access to the cube and IUSR is in  olapAdmin group
> > I tested this account with login to a pc and access OLAP from Excel, and
> it
> > works fine. But it does not get the access from internet.



> > > What did you give the IUSR account access to?  You need to set it up
as
> > > a role in one of the cubes if you have any security setup?

> > > You can test this by giving EVERYONE access to the cube and seeing if
> > > this works.

> > > --
> > > Posted via http://dbforums.com

 
 
 

Internet User can not connect to MSOLAP

Post by Creative Bo » Fri, 13 Jun 2003 02:04:45


Dear Friend,

I've selected some links that will help you in your problem.

http://support.microsoft.com/default.aspx?scid=%2Fservicedesks%2Fwebc...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsq...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olap...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsq...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsq...


Quote:> Hi

> The IIS is running 2000 Server and OLAP is running on NT 4.0.   I set the
> Directory Security on the folder for the IUSR_Server . The IUSER_Server
has
> access to the NT 4.0 which is running MSOLAP, But the users connecting frm
> internet can not connect to the olap.
> Is there any tracing or logging that I can do on Analysis Server that
would
> tell me what is the use name and password IIS is passing?
> thanks

 
 
 

1. Connect from another machine as internet user

Hi all,

I have two machines in mydomain. m1(dc) is the place where sqlserver is
located; m2 is the box where iis(m2) installed. I have configured the
iis(m1) and sqlserver so user IUSR_m1(Windows account) can access the
database via sql virtual directory in iis(m1). I want the user IUSR_m2 can
access the databse via iis(m2) as well, but the new "login" in sqlserver
doesn't bring out user IUSR_m2 on its list. How can I deal with this?

TIA

Sean

2. DTS Package

3. MSOLAP.1 vs MSOLAP.2

4. USA-NY-Oracle Designer Data Modeler

5. Provider MSOLAP.1 x MSOLAP

6. Delphi and Redirection when exporting

7. limit user connect from internet?

8. error 3343 Unrecognized format "v:\projekt.mdb"

9. Anon Internet User Connecting to SQL Server via ASP

10. GET CONNECTED TO WORLDWIDE DISTRIBUTED DATABASE OF USERS OF INTERNET

11. Connecting via internet with another domain user

12. Connecting a PivotTable to a MSOLAP.2 string

13. Connect to MSOlap server