authentication on analysis server

#1

Hi,

could anyone tell me why the analysis server does not require a login name
and password like the standard sql server and so how it is secured? Is it
possible to set up an account like that on the analysis server (i.e. so that
chosen people can log in to it from anywhere and access an OLAP cube, but
with limited priviledges)?

thanks!

#2

That's not entirely correct. You can use http connectivity to connect using
a machine account. UserIds and passwords in the connection string are used
by basic authentication (if IIS setup correctly).

--
_______________
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.

"Brian Altmann" <findme@thesignaturewebsite> wrote

Quote:

AS 2000 can only be used with Integrated Security, that is to say, you
have
to be a Windows domain user. You map domain users to AS objects using
Database and Cube roles. If you specifiy user/password in the connection
string, they are ignored and the credentials of the Windows user running
the
app that creates the connection are used instead.
HTH,
Brian
www.geocities.com/brianaltmann/olap.html

"Programmer" wrote:

Hi,

could anyone tell me why the analysis server does not require a login
name
and password like the standard sql server and so how it is secured? Is
it
possible to set up an account like that on the analysis server (i.e. so
that
chosen people can log in to it from anywhere and access an OLAP cube,
but
with limited priviledges)?

thanks!

#3

thanks!

"Brian Altmann" <findme@thesignaturewebsite> wrote

Quote:

AS 2000 can only be used with Integrated Security, that is to say, you
have
to be a Windows domain user. You map domain users to AS objects using
Database and Cube roles. If you specifiy user/password in the connection
string, they are ignored and the credentials of the Windows user running
the
app that creates the connection are used instead.
HTH,
Brian
www.geocities.com/brianaltmann/olap.html

"Programmer" wrote:

Hi,

could anyone tell me why the analysis server does not require a login
name
and password like the standard sql server and so how it is secured? Is
it
possible to set up an account like that on the analysis server (i.e. so
that
chosen people can log in to it from anywhere and access an OLAP cube,
but
with limited priviledges)?

thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

authentication on analysis server

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

authentication on analysis server - 09-15-2004 , 06:19 AM

Re: authentication on analysis server - 09-15-2004 , 01:43 PM

Re: authentication on analysis server - 09-15-2004 , 02:29 PM