Hello,

Can SSAS 2005 work in network were primary authentication is based on Novell
network?
Can I do this without using OLAP over http connection?

Thanks

Hello Vimas,

Nice to see you again in the newsgroup. SSAS only supports Windows
authenction on the server side. Therefore, usually clients cannot access AS
without proper credential by using correct authentication method such as
NTLM or kerberos. You can use Novell if you can somehow get Windows to
treat you clients as having valid Windows NT credentials. Your network
administrators might be aware of some various options.

PSVR2002: Pivot Table Does Not Work and Project Server Stops Responding
http://support.microsoft.com/kb/812636

http://www.microsoft.com/technet/pro...02/deploy/ntrs
tdom.mspx

As you know, to work with AS in a "domain free" environment, you 'd better
use an http-connection (OLAP over http) between client and server. Please
see "Domain Structure Issues" part of the following link for more details:
http://www.microsoft.com/technet/pro.../anservog.mspx

If anything is unclear or you have any comments or feedback, please feel
free to let's know. Thank you

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

I did this once back in 2002, but it was not very pretty.

At the time the Novell login screen had the ability to specify a
windows account which was used to log on to the local machine. If you
create a local account on the server that is running SSAS with an
identical username and password to the account on the workstation, it
should "map" the two accounts. If you have assigned the accounts on
the server to the relevant OLAP roles you should be good to go.

Regards
--
Darren Gosbell - SQL Server MVP
blog: http://geekswithblogs.net/darrengosbell

On Fri, 24 Nov 2006 03:20:09 GMT, petery (AT) online (DOT) microsoft.com (Peter
Yang [MSFT]) wrote:

I thought I had this working under AS2000.
In AS2005 I can see the metadata in BI Studio and Enterprise manager but if
I go to Browse the cube I can't see the data.
Is there something more to it?


"Darren Gosbell" wrote:

If you can see the cubes and dimensions, you should be able to view the
data.

Are you able to deploy and process the Adventure Works sample? I am
assuming that you have migrated an As 2000 database up to 2005 and just
think it would not hurt to test against the sample database. It could be
that there is an issue (other than permissions) with your database that
is preventing the data from displaying.

One such possibility is that you could be missing the "calculate;"
statement at the top of the calculation script.

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

In article <5125B4A3-1808-4D62-B40C-621B6DFA03B7 (AT) microsoft (DOT) com>,
acius (AT) nospam (DOT) nospam says...

Thanks Darren,

It appears security related.
Changed it from a group (that included the user) on the database level to
allowing the user on the server level and it works.

Haven't figured out exactly which bit of this is blocking the cube browser.

"Darren Gosbell" wrote: