Reverting back to Windows Authentication

Hi,
Does anyone know if and how easy it is to revert back to just Windows
authentication on the sql server from Mixed Mode ?
Thanks,
Luke.Its all a switch you need to toggle to change to windows authentication mode
under the security tab in SQL Server Properties in EM.
Not too sure how to do the same without using the EM. But make sure you have
no apps using SQL authentication and can be confirmed using profiler.
"Luke Fields" <lfields228@.hotmaik.com> wrote in message
news:u0Yu4mylDHA.2456@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Does anyone know if and how easy it is to revert back to just Windows
> authentication on the sql server from Mixed Mode ?
> Thanks,
> Luke.
>|||Be aware that it does require a SQL Service restart. If you don't have EM
look at
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q285097
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:e9hZmLzlDHA.2536@.tk2msftngp13.phx.gbl...
Its all a switch you need to toggle to change to windows authentication mode
under the security tab in SQL Server Properties in EM.
Not too sure how to do the same without using the EM. But make sure you have
no apps using SQL authentication and can be confirmed using profiler.
"Luke Fields" <lfields228@.hotmaik.com> wrote in message
news:u0Yu4mylDHA.2456@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Does anyone know if and how easy it is to revert back to just Windows
> authentication on the sql server from Mixed Mode ?
> Thanks,
> Luke.
>