"Eugene" <eugene.chen (AT) iwl (DOT) com.au> wrote

Hi Eugene,

What are the authentication modes in the virtual directory where you put
msolap.asp ? If you didn't change them - you will get anonymous
authentication, which can explain why you get the error message you get.
If you try your second method, either by hardcoding Password and Username
(not really secure), or by putting "Prompt=1" in the connection string to
cause the user enter password/user name, you need to make sure that IIS
authentication mode on the virtual directory is set to "Basic
Authentication"

I certainly don't agree with this conclusion. From my experience,
performance problems with OWC don't depend on whether or not it works over
Internet, but on the structure of the cube, size of dimensions and
complexity of calculations inside the cube.

HTH,
Mosha.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================