[Guide] Change MsSQL sa Password

ReaL

New Member
Joined
Apr 13, 2008
Messages
1,244
Reaction score
656
Changing MsSQL 'sa' account password:


1st Method

Start > All Programs > Microsoft SQL Server > Query Analyzer
Code:
sp_password NULL,'[COLOR="Red"]new_password[/COLOR]','sa'
GO


2nd Method

Start > All Programs > Microsoft SQL Server > SQL Server Enterprise Manager
Security > Logins > Right Click On 'sa' > Properties
Code:
Under "[B]Authentication[/B]" Tab, in "[B]Password[/B]" field, type your [COLOR="Red"]new password[/COLOR]
 
това ми трябваше мерси :p