SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 forget password sa in sql server 2005
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

pamyral_279
Posting Yak Master

134 Posts

Posted - 01/29/2007 :  03:36:02  Show Profile
I have forgotten password of user sa in sql server 2005.
But if authentication is window . I still login, and do work normal.
So how to solve problem ,if authentication is sql server.
Thank you very much.

khtan
In (Som, Ni, Yak)

Singapore
17626 Posts

Posted - 01/29/2007 :  03:38:45  Show Profile
use the administrator a/c in the Server machine to login and reset sa password


KH

Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30240 Posts

Posted - 01/29/2007 :  03:46:11  Show Profile  Visit SwePeso's Homepage
Or try this, if you previously has added your database server to the SSMS or EM console with SA account.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=77541


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

dizzyturkey
Starting Member

China
2 Posts

Posted - 02/03/2010 :  02:17:50  Show Profile
MS SQL Server Password Unlocker helps to reset sa password saved in master.mdf of SQL server 2005! I had forgotten the sa password last week, and I fortunately found the MS SQL Server Password Unlocker at a password recovery blog. There are many password recovery solutions including SQL password recovery.

url removed
Go to Top of Page

yitiana
Starting Member

USA
7 Posts

Posted - 08/17/2010 :  22:06:08  Show Profile  Visit yitiana's Homepage
Change SQL Server Password by Windows Authentication

Edited by - yitiana on 08/20/2010 01:46:55
Go to Top of Page

james8421
Starting Member

1 Posts

Posted - 05/10/2011 :  10:34:16  Show Profile
I usually use SQL Server Password Changer 1.3 program.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000