Mohit Agrawal

Success is Journey it's not a destination

Menu

  • Home
  • Sql server 2008
  • Differences

March 9, 2011

Sql Server: How to change 'sa' password

Step1 : goto start->run cmd [Enter]
In a command prompt

Step2 : c:\Documents and Settings\User>cd\ [Enter]
Step3 : c:\osql -E [Enter] {Its Login through Window authentication}
Step4 : 1> sp_password @old=null, @new='newpassword', @loginame='sa' [Enter]
Step5 : 2> go [Enter]
Step6 : 1> Exit [Enter]

Now password changed successfully.
Posted by Mohit No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Search This Blog

Index

  • ►  2017 (1)
    • ►  February (1)
  • ►  2016 (1)
    • ►  February (1)
  • ►  2014 (2)
    • ►  March (2)
  • ►  2013 (1)
    • ►  January (1)
  • ►  2012 (3)
    • ►  December (1)
    • ►  October (1)
    • ►  February (1)
  • ▼  2011 (1)
    • ▼  March (1)
      • Sql Server: How to change 'sa' password
  • ►  2010 (4)
    • ►  May (2)
    • ►  March (2)
  • ►  2009 (22)
    • ►  November (1)
    • ►  October (6)
    • ►  August (3)
    • ►  July (2)
    • ►  June (3)
    • ►  May (3)
    • ►  March (4)
  • ►  2008 (17)
    • ►  December (1)
    • ►  September (1)
    • ►  August (1)
    • ►  April (2)
    • ►  February (12)
Mohit
View my complete profile

Blogs

  • AngularJS
  • Asp.net
  • Vb.net Link
  • Obect Oriented Programming
Ethereal theme. Powered by Blogger.