OLAP Services Authentication and Novell Netware 
Author Message
 OLAP Services Authentication and Novell Netware

I have recently installed OLAP Services and some cubes for a client, just to
show them how they can better use, analyse and visualise the data in their
ever growing SQL 7 DB. We set up a new server for the Data Warehouse and
OLAP and linked it to the old server with the original SQL 7 DB. The DTS
packages transfering and modifying the data, are running fine, doing
automatic updates on a daily basis.
Our only problem was that none of our users could access the OLAP Server.
This was set up according to the "book" with Windows NT authentication, the
right domains, etc., etc. I had even set up a "mirror site" in my own
company and "everything works for us", of course.
The only difference, which we could not emulate, was that our client uses
Novell Netware for user identification. The problem must be with Netware we
reasoned, so we set up a new workstation without Novell and using only
Windows NT authentication, and at last we could see the cubes from a remote
station.
Our solution to the problem is to add each OLAP User to the local users on
the OLAP server, userid and password identical to that in the domain and in
Netware. This works fine, but I am not happy about it. With an increasing
number of OLAP clients, it could become an Administrative nightmare,
particularly with regular password changes.
Does anyone know a better solution?
/Eivind


Tue, 26 Aug 2003 00:37:00 GMT
 OLAP Services Authentication and Novell Netware

My client has the same environment: Novell Clients and WNT Domains. What we
did: Installed Novell Client for Eindows AND Client for Microsoft (Control
Panel/Network). And the clients workstation must log on to Netware and Win
NT Domain; yes, the user must have two accounts and two passwords. But if
both paswwords are the same, Novell won't prompt the user for typing it
again.

Claudio Chiba


Quote:
> I have recently installed OLAP Services and some cubes for a client, just
to
> show them how they can better use, analyse and visualise the data in their
> ever growing SQL 7 DB. We set up a new server for the Data Warehouse and
> OLAP and linked it to the old server with the original SQL 7 DB. The DTS
> packages transfering and modifying the data, are running fine, doing
> automatic updates on a daily basis.
> Our only problem was that none of our users could access the OLAP Server.
> This was set up according to the "book" with Windows NT authentication,
the
> right domains, etc., etc. I had even set up a "mirror site" in my own
> company and "everything works for us", of course.
> The only difference, which we could not emulate, was that our client uses
> Novell Netware for user identification. The problem must be with Netware
we
> reasoned, so we set up a new workstation without Novell and using only
> Windows NT authentication, and at last we could see the cubes from a
remote
> station.
> Our solution to the problem is to add each OLAP User to the local users on
> the OLAP server, userid and password identical to that in the domain and
in
> Netware. This works fine, but I am not happy about it. With an increasing
> number of OLAP clients, it could become an Administrative nightmare,
> particularly with regular password changes.
> Does anyone know a better solution?
> /Eivind



Fri, 05 Sep 2003 22:15:46 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Windows Authentication in Novell Netware Environment?

2. OLAP authentication from Netware clients

3. Analysis Services Authentication and Netware

4. Can SQL Server 2000 Analysis Services run in a Novell Netware network

5. nochmal korrigierte Service Packs füer Netware, jetzzt von Novell freigegeben

6. Enterprise OLAP Services vs Std Olap Services

7. Olap desktop Client Cannot Connect To Another Desktop Olap Services

8. Upgrade from OLAP Services to Analysis services

9. What's New In Analysis Services 2000 (a.k.a OLAP Services)

10. User authentication from NetWare NDS?

11. How different is Analysis Services from OLAP Services?

12. Analysis Services / Olap Services Web Site.


 
Powered by phpBB® Forum Software