Hi Sharma,
what do mean by *ENABLE* ?
If i am not able to open my sql server thru Enterprice
manager, then how should i change the security
authentication to windows login id ?
is there is any stored procedure to enable windows
authentication?.
Ok. i can login into Win'2000 server as Admn, then how
to change the SA password ?
Can u pls give one example ?
Regards,
Bajal
--- Sushil K Sharma <sushil.[Email Address Removed] Hi Chuk,
> Assuming you are able to logon to windows NT/2000
> server (PC where the SQL server is installed) with
> the NT Administrator account. If yes, then you just
> need to *ENABLE* the Windows Authentication. Now you
> can logon to SQL server without providing any
> password. Now you can change the sa password.
>
> HTH
>
> Sushil K Sharma
> Sr. Systems Specialist
> TIL NEPZ
>
> -----Original Message-----
> From: Speaks, Chuck W.
> [SMTP:Chuck.[Email Address Removed] Sent: Wednesday, May 22, 2002 1:34 AM
> To: '[Email Address Removed] Subject: RE: Changing Lost SA Password
>
>
>
> I have a remote admin that setup a SQL Server
> instance a while back and has
> forgotten the sa password. I recall hearing
> something about a stored
> procedure that will change the sa password without
> knowing the current
> password. Does anyone have any information on this
> process?
>
> Thanks,
> Chuck
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]
=====
With warm wishes,
S.Bajal Mohamed
Tek-Modular Sdn Bhd
lot 4858, Jln Panglima
KB KA 3131
Brunei Darussalam.
Tel : 673 + 3 + 331415 (off)/ 332785 (Res).
__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
MS Sql Server LazyDBA home page