SQL Server Forums - forget password sa in sql server 2005

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

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

Topic

pamyral_279
Posting Yak Master

129 Posts

Posted - 01/29/2007 : 03:36:02

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
16769 Posts

Posted - 01/29/2007 : 03:38:45

use the administrator a/c in the Server machine to login and reset sa password

SwePeso
Patron Saint of Lost Yaks

Sweden
29156 Posts

Posted - 01/29/2007 : 03:46:11

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

dizzyturkey
Starting Member

China
2 Posts

Posted - 02/03/2010 : 02:17:50

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

yitiana
Starting Member

USA
7 Posts

Posted - 08/17/2010 : 22:06:08

Change SQL Server Password by Windows Authentication

Edited by - yitiana on 08/20/2010 01:46:55

james8421
Starting Member

1 Posts

Posted - 05/10/2011 : 10:34:16

I usually use SQL Server Password Changer 1.3 program.

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.08 seconds.