- 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
2nd Method
Start > All Programs > Microsoft SQL Server > SQL Server Enterprise Manager
Security > Logins > Right Click On 'sa' > Properties
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]