Why AS2005 has only Windows Authn unlike SS2005?

Hot Topic

Linux user: creating databases
Copy Database
Update conflict
Hide Results Pane is gone??
How to use cubes of 2000 in 2005
Spaces in Column names
Finding Containers and Variables from Script task?
Metadata driven SSIS
Join filter failure
Running a package in C#

SQL Server

Underlay possible?
Data Comparison Question
cannot install SQL Server Express, keep getting errors
Not enough memory to start "Query processor"
An internal error occurred on the report server. See the error log for more details.
Cannot Set Connection String For Bulk Insert Source Connection
SSIS Connection Manager
Second instance of Reporting Service cannot get to web page
SSIS Import and Export Wizard Data Sources
SSIS package won't run in production server

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?

  • MiguelGandia

    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.



  • develronioder

    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.



  • Ninja

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


  • @nt

    Thanks for the responses.

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

    Thanks,

    JGP

  • Brendan Egan

    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
  • Why AS2005 has only Windows Authn unlike SS2005?
Answer this question