Re: Impact of Changing Authentication Mode

From: Keith Wilson [MSFT] (Keith.Wilson_at_online.microsoft.com)
Date: 10/06/05

  • Next message: Sue Hoegemeier: "Re: Securing SQL Server after administration installation" 
    Date: Wed, 5 Oct 2005 16:09:52 -0700

    With either SQL Server 2000 or SQL Server 2005, the process is virtually
    identical as follows:

    Run SQL Enterprise Manager (or Start > Run > SQLwb.exe if using 2005)
    Connect to the server
    Launch Server Properties dialog
    Switch to the Security tab
    Select the Authentication option (Mixed or Windows only) > OK
    Dismiss the "restart the server to implement changes" message box
    "Restart" the MSSQLServer service (Start > Run > Compmgmt.msc >
    services.msc)

    Regards,
                      Keith

    This posting is provided "as is" without inferring rights or warranties.

    "Joe Yong" <NO_jyong_SPAM@scalabilityexperts.com> wrote in message
    news:OVSeLmxvFHA.1032@TK2MSFTNGP12.phx.gbl...
    > One extra door to guard?
    >
    > Not sure what you mean by impact. From a performance or resource overhead
    > perspective? Nothing there. From a security perspective, you now need to
    > figure out how to manage the SQL Server logins to ensure they follow your
    > password policies (complexity, length, expiration, re-use, etc...). Not
    > much help built into SQL Server 2000 but in 2005, life gets a LOT better.
    >
    >
    > joe.
    >
    >
    > "Suhas Vengilat" <SuhasVengilat@discussions.microsoft.com> wrote in
    > message news:34F882D9-448F-4EDC-A62C-BB87CCAF9307@microsoft.com...
    >> Hi,
    >>
    >> Our application using an SQL 2000 database, which is currently using
    >> Windows
    >> Authentication. For some reason, we need to change the access mode to
    >> mixed
    >> mode. Could someone please throw some light on the impact of this change.
    >>
    >> Thanks in advance
    >> Suhas
    >
    >

  • Next message: Sue Hoegemeier: "Re: Securing SQL Server after administration installation"

    Relevant Pages

    • Re: Slow booting xp home.
      ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
      (microsoft.public.windowsxp.perform_maintain)
    • Re: Slow booting xp home.
      ... Thirty seconds to boot Windows? ... I read somewhere that Microsoft suggest 30s boot up on xp home, I have seen videos on youtube of 8s boot up on xp, I'd be delighted with 30s and happy just to get below a minute. ... Installing and Registering Visual Studio Express Editions Smart Device ...
      (microsoft.public.windowsxp.perform_maintain)
    • Re: Remote connection failed
      ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
      (microsoft.public.sqlserver.connect)
    • Getting to the bottom of MSDE network connection problems ...
      ... but other than that it is MSDE 2000 with sp3a already applied. ... I've finally figured out the connection problems associated with this, ... and it seems the problems are due to Windows XP and not MSDE. ... the enterprise/standard versions of SQL server won't install ...
      (microsoft.public.sqlserver.msde)
    • Re: Security Update for SQL Server 2005 Service Pack 2 (KB948109)
      ... If you're running Windows Live Mail, sign out then close the application. ... Understand that you can open a free support incident about your issues: ... When you call, clearly state that your problem is related to a Security Update and cite the update's KB number. ... SQL Server Database Services 2005 ENU SP2 ...
      (microsoft.public.windowsupdate)