SQL authentication - mixed mode and windows auth

Posted on 2007-08-01
Last Modified: 2008-03-10
What is the differences (security wise) in Mixed Mode  and windows authentication in SQL 2000?
Question by:tlperkins
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    mixed mode allows both Sql logins AND windows authentication logins.
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    Mixed mode allows you to use both SQL +Windows authentication.So if you use Windows authentication, then you will get all the security features of that windows user.

    Author Comment

    I knew that but what is the security details of that?
    LVL 20

    Expert Comment

    LVL 35

    Expert Comment

    LVL 5

    Accepted Solution

    Windows Authentication Mode  - is the default authentication mode in SQL Server 2000. In this mode, the SQL Server 2000 relies solely on the Windows authentication of the user. Windows users or groups are then granted access to the SQL Server. Connections made to the server using this mode are known as trusted connections.

    When Windows Authentication Mode is used, the database administrator allows users to access the computer running SQL Server by granting them the right to log in to SQL Server 2000. Windows security identifiers (SIDs) are used to track Windows authenticated logons. As Windows SIDs are used, the database administrator can grant logon access directly to Windows users or groups.

    In Mixed Mode, users can be authenticated by Windows Authentication or by SQL Server Authentication. Users who are authenticated by SQL Server have their username and password pairs maintained within SQL Server.

    Connections that rely on username and password pairs are called non-trusted connections, or SQL connections.


    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now