Hi

I have a serious issue that I would like some help with.

My customer has a combined Novell/Windows networking environment. Through a
set of tools both environments are kept in sync as far as users and passwords
are concerned. None of the workstations is a member of the Windows Domain.

The customer's workstations are all logging into the Novell environment.
When I try to connect to an Analysis Cube (SQL Server 2000/Analysis Services
Standard Edition SP3a) from Excel 2000 using a pivottable I get an error
message saying that authentication is not possible.

In fact I presume that Excel is picking up the User ID and Password from the
workstation and is passing that on to SQL Server/Analysis Services. Since the
Userdomain of the workstation is the workstation itself this seems to go
wrong. When I make the workstation a member of the windows Domain it works
fine. However, this is not really an option for the customer.

I there any way to get this to work? Can I have Excel prompt me for the
userid, password and Domain? Or is there a workaround? Or any other solution
or remark?

Thanks

Ralf

Hi,

to work with AS in a "domain free" environment, you have to use an
http-connection between client and server. In this case you can connect to
the server using windows authetification, the IIS-anonymous account or
defining individual users, passed through using basic authentification in
IIS for the file msolap.asp

cheers,
Matthias

"RaVaGe" <RaVaGe (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:70D6245D-6EDE-45A3-90B0-7E98A1EFB70A (AT) microsoft (DOT) com...

See the security configuration section in the SSAS Operations Guide:
http://www.microsoft.com/technet/pro.../anservog.mspx

--
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.

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

Thanks for this info. But is there a way to tell the pivottable wizzard to
use a certain, username, password en domain? That would solve my problem, but
I don't how to do that, if at all possible.

Ralf

"Dave Wickert [MSFT]" wrote:

It is on the connectstring. See BOL under PTS Properties. You can enter
username as "domain\user" and pwd as the password. If using http access make
sure that you always run SSL (and specify https://<server>) so that the
basic authentication headers are encrypted, otherwise the username and
password are only lightly modified when sent over the wire.
--
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.

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

Dave

As I read in the BOL this only works when using the HTTP or HTTPS
connection. Is this correct? What I'm trying to do is to connect from within
Excel to Analysis Services Standard (not Enterprise) using the Pivottable
wizard. This means I cannot use HTTP. Is this correct? And does this mean I
cannot get this to work without using the Enterprise Edition of SQL Server?

Thanks, Ralf


"Dave Wickert [MSFT]" wrote:

You are correct.
HTTP connectivity is an Enterprise Edition feature.
If you limited to only using Standard Edition, then you are forced to use
Windows integrated security.

That being said however, you can use Novell if you can somehow get Windows
to treat you as having valid Windows NT credentials. Your network
administrators are probably well aware of your various options. If all else
fails, the SSAS Operations Guide has several backdoor techniques you can
use, such as enabling the NT Guest account (and others). However, you must
ultimately come down to an NT account.

Hope this helps.
--
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.

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

Dave Thanks. This definitely was a great help. At least I now know what the
possibilities are. And I can inform my client in the correct manner.

Regards, Ralf

"Dave Wickert [MSFT]" wrote: