HOLD On...

Also, First create all sql login authentications which
were using windows auth. and look for application
settings also(it may create some errors on some
applications)

All the Best,
San

--- Singh Jitender <jitender.[Email Address Removed] wrote:
> yes, it is possible.
> goto sql server enterprise manager--> right click on
> server icon for
> properties
> then switch to <security> tab . on security tab u
> can see authentication
> ==> select 'sql server and windows' option and click
> <ok> button to save the
> settings.
> before that u hv to modify 'sa' login for
> password[can find under security
> folder].
>
>
>
> -----Original Message-----
> From: Ravinder Singh [mailto:[Email Address Removed] Sent: Thursday, January 30, 2003 5:07 PM
> To: LazyDBA.com Discussion
> Subject: Authentication Question
>
>
> Hi Friends,
>
> When one of my colleagues installed SQL Server he
> installed it with Windows
> authentication.
> Now he wants to switch to SQL Server authentication.
>
> Is it possible to do so, if yes then pl let us know
> how?
> or he would have to reinstall again with SQL Server
> authentication?
>
> Thanks and regards,
> Ravinder
>
>
---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> JUST REPLY
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
MS Sql Server LazyDBA home page