Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    163

    Unanswered: How do I check SQL Server's Mode?

    How do I check if SQL Server is set to Mixed mode or not?


    Also, what other modes are possible (in addition to Mixed Mode) and how do I check these?


    Last: What really do we mean by "Mixed Mode".


    Thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: How do I check SQL Server's Mode?

    Originally posted by Joozh
    How do I check if SQL Server is set to Mixed mode or not?


    Also, what other modes are possible (in addition to Mixed Mode) and how do I check these?


    Last: What really do we mean by "Mixed Mode".


    Thanks.
    to check the mode
    Expand a server group.

    Right-click a server, and then click Properties.
    Click the Security tab.
    if sql server and windows is selected it is mixed mode


    for more details on mixed mode
    check out "Authentication modes " in BOL

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Mixed Mode allows users to connect to an instance of SQL Server using either Windows Authentication or SQL Server Authentication. Users who connect through a Windows NT 4.0 or Windows 2000 user account can make use of trusted connections in either Windows Authentication Mode or Mixed Mode.

    SQL Server Authentication is provided for backward compatibility. For example, if you create a single Windows 2000 group and add all necessary users to that group you will need to grant the Windows 2000 group login rights to SQL Server and access to any necessary databases.

    Whenever possible use Windows authentication only.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Oct 2003
    Posts
    163
    Thanks harshal and satya. Many thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •