Why AS2005 has only Windows Authn unlike SS2005?

Hot Topic

INSERT Not Working via Emulator SmartPhone WM 5.0
"Using Object Data Sources in a Report" - for Web Apps? (VS 2005)
can some one please tell me about the server name??
SQL Task with Variables
Integration Services extraction/loading throughput/performance
How to generate SP scripts
problem on running replication on pocket pc
Execute script from Stored Procedure
Is it possibly to rollback a whole package if one dataflow fails?
copying table in a database

SQL Server

Failed to connect to sql server
how to alternate the colours on a column with parent-child dimension
NS 2.0 SP1 Install Problem
Loading 2000 backup to SQL Server 2005
table or view doesn't exist
Concatination of empty field and removal of "" symbols
what i forgot
Web Application sample for Data Mining using Association Rules
FULL SEARCH
comment/uncomment keyboard shortcuts changed .. grrrrr!!!!

Why AS2005 has only Windows Authn unlike SS2005?

Hi,

I was wondering why AS2005 has only windows authentication, unlike SS2005 which has its own users and roles. What was the reasoning behind this

Just trying to understand so I can explain to my peers\boss why we need to setup Windows domain users for our web-based app which has an OLAP front end.

Thanks,

JGP

Answer this question

Why AS2005 has only Windows Authn unlike SS2005?

  • 　平 明?

    As Edward said, going into "why" argument can become a lengthy discussion, but since you wrote that you have middle tier Web app, have you considered using technique of setting Roles connection string property - this will save you from creating Windows domain users...
    ==================================================
    Mosha Pasumansky - http://www.mosha.com/msolap
    Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
    All you need is love (John Lennon)
    Disclaimer : This posting is provided "AS IS" with no warranties, and confers no rights.
    ==================================================


  • David T So

    Here is some useful information about Analysis Services security.
    http://www.mosha.com/msolap/security.htm

    Hope that helps.
    Edward.
    --
    This posting is provided "AS IS" with no warranties, and confers no rights.



  • Trond Undrum

    Thanks for the responses.

    Mosha, Could you point me to some links or articles which explain the technique you mentioned

    Thanks,

    JGP

  • Andy Bolton

    I checked those articles. But it still doesn't explain the "why" part.

    Any idea why Analysis Services authenticates only using Windows Authn. whereas SQL has mixed mode authn

    Thanks,

    JGP

  • supercalafragalistic

    Why implement one security model and not another is such a broad topic.

    For one you can do a little research and find reasons why Mixed mode in SQL Sever is is considered inferior to Windows auth mode from security perspective.

    Sorry for being a bit short, but any argument requires a bit of discussion.

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



  • Why AS2005 has only Windows Authn unlike SS2005?
Answer this question