Hi

We are using BIP Portal 2003 with AS 2000 SP3. Sharepoint, AS and the BIP
portal work perfectly for users which belong to the administrators group.
The rest of the users can load the sharepoint page, de OWC object, but no
data is displayed. If I try to create a new data source, the error "Server
not found or access denied" is shown.

We are granting access using an AS role. We tested adding the user account,
a user group, the "domain users" group, with no success. It looks like
something prevents non-administrators user from login into the AS service.
As soon as we add a user account to the administrator group, the views start
working.

I'll appreciate any idea of what to check in our setup.

The server is MSSQL 2000 Std. SP3a on a Win2k3 dual cpu server.

Thanks.

--
Carlos Gutiérrez
http://sca.com.mx

If you put the Everyone account in the role does it work for the users that
are not admins?
What is the version of the MSOLAP80.DLL on the client machine?


David Botzenhart

"Carlos Gutierrez" <carlosg (AT) NOSPMsca (DOT) com.mx> wrote

David,

Thanks for your repliy.


Msolap80.dll created 12/18/2002 4:09:24 am size 1.97 MB

Regards,

Carlos Gutiérrez

Hi,

you might want to check out following KB Entries:

http://support.microsoft.com/kb/273836/en-us

and

http://support.microsoft.com/kb/273836/en-us

I once had a customer with small infrastructure and PDC on the same machine
as AS.

Hope I helped
Monte

"Carlos Gutierrez" wrote:

Monte,

Thanks a lot, I'll research those KB, but


Thanks!

Yes, that's the case.

--
Carlos Gutiérrez
http://sca.com.mx

Sorry, here is the other link:
http://support.microsoft.com/default...b;en-us;826310

We had to rebuild the customers infrastructure and seperate PDC and AS to
get it working. We had the same situation (only domain-admins could log on)
.... I believe they are due to the mixture of local OLAPAdmin-Group and the
"no local administrator group" situation on a PDC ;-)

Good luck
Monte

"Carlos Gutierrez" wrote:

You are right. On a primary domain controller, local machine groups are also
global groups. This means that the local OLAP Administrators group was being
exposed as a global group. And by default the only members in that group are
local machine administrators and there are none of those on a primary domain
controller. Thus the only people who have default admin permissions from an
OLAP point of view are domain admins.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Monte" <Monte (AT) discussions (DOT) microsoft.com> wrote

Monte and Dave,

Thanks a lot for the information.

So, the only option is to move AS to another computer? Or is there a
workaround?

Thanks.

Carlos Gutiérrez