Computers & Internet Logo

Related Topics:

Posted on Sep 15, 2010
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

I forgot my sql server password, and i need to get the sql sa password back, how can i retrieve my sql sa password? its SQL server 2005. Any advice is ok, i dont want to reinstall the SQL server, Thanks in advance.

9 Answers

Mixlysis Zuna

Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Passionate:

Visited the website for 10 consecutive days.

Habit-Forming:

Visited the website for 3 consecutive days.

  • Expert 49 Answers
  • Posted on Apr 28, 2020
Mixlysis Zuna
Expert
Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Passionate:

Visited the website for 10 consecutive days.

Habit-Forming:

Visited the website for 3 consecutive days.

Joined: Feb 29, 2020
Answers
49
Questions
0
Helped
10673
Points
178

Hey,
To recover the SQL server password you can use the manual as well as automated approach. The manual method is quite tricky and data loss possibility is higher than the usual. So opting for a manual method is not a smart choice. So here you can use automated software such as SQL Server password recovery software by SysInfo Tools. For further information you can go through the link :-

https://www.sysinfotools.com/recovery/sql-server-password-recovery.php

marilynhudson

Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Habit-Forming:

Visited the website for 3 consecutive days.

New Friend:

An expert that has 1 follower.

  • Expert 61 Answers
  • Posted on Dec 01, 2016
marilynhudson
Expert
Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Habit-Forming:

Visited the website for 3 consecutive days.

New Friend:

An expert that has 1 follower.

Joined: Nov 05, 2016
Answers
61
Questions
0
Helped
15346
Points
375

Stellar Phoenix SQL Password Recovery with amazingly simple interface. It recovers all the SQL passwords with its minimalistic approach. Within few steps, you can recover password with ease.

Ad

John Walker

Level 2:

An expert who has achieved level 2 by getting 100 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Social Spider:

An expert who has shared 50 answers on their Facebook wall.

  • Expert 47 Answers
  • Posted on May 21, 2016
John Walker
Expert
Level 2:

An expert who has achieved level 2 by getting 100 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Social Spider:

An expert who has shared 50 answers on their Facebook wall.

Joined: Aug 07, 2015
Answers
47
Questions
0
Helped
26133
Points
349

- Open SQL Server Configuration Manager
- Stop the SQL Server Instance you need to recover the SA password
- Open the properties on the SQL Server Instance and click on the Advanced tab
- Change the Startup parameter by adding -m; at the begging of the line and click OK
- Start the SQL Service Instance

If this won't work for you then you can take the help of third party SQL Server Password Recovery Software: http://www.dbpros.org/sql-server/password-recovery.html

Platter Simmons

Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

  • Contributor 1 Answer
  • Posted on Jun 12, 2014
Platter Simmons
Contributor
Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

Joined: Apr 08, 2014
Answers
1
Questions
0
Helped
770
Points
1

I would like to suggest you to use of third party tool named as Kernel for SQL Password Recovery tool to recover alternate passwords for multiple MDF files of SQL server. The software is also compatible with all versions of windows operating systems.

Anonymous

Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

Corporal:

An expert that has over 10 points.

Problem Solver:

An expert who has answered 5 questions.

  • Contributor 14 Answers
  • Posted on Jun 21, 2012
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

Corporal:

An expert that has over 10 points.

Problem Solver:

An expert who has answered 5 questions.

Joined: Jun 19, 2012
Answers
14
Questions
0
Helped
14174
Points
14

Lost or forgot your administrator/user password for Microsoft SQL Server?
If so, turn to help from AnyPasskey SQL Password Recovery, which is a professional program enables you reset administrator or user password for Microsoft SQL Server instantly regardless of the length, complexity, language and encoding of the password set before. As long as you got AnyPasskey SQL Password Recovery and master.mdf file, you could reset SA password on any authorized PC in minutes without the installation of Microsoft SQL Server. What's more, this featured-in tool supports all versions of Microsoft SQL Server and Microsoft SQL Server Express perfectly. I forgot my sql server password, and i need to get - 6_21_2012_1_55_07_am.jpg

Anonymous

Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

Mayor:

An expert whose answer got voted for 2 times.

  • Contributor 3 Answers
  • Posted on Mar 07, 2012
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

Mayor:

An expert whose answer got voted for 2 times.

Joined: Mar 07, 2012
Answers
3
Questions
0
Helped
2245
Points
5

Forgot SQL Server password? Don't be panic! With SQL Server Password Changer you can easily reset lost or forgotten SA password on SQL Server 2000/2005/2008, get instant control over locked databases no matter how many instances of Microsoft SQL Server are running. No need to reinstall SQL Server! Never worry about losing the SA password!

Anonymous

Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

Filmmaker:

Uploaded 5 video answers.

New Friend:

An expert that has 1 follower.

  • Contributor 91 Answers
  • Posted on May 31, 2011
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

Filmmaker:

Uploaded 5 video answers.

New Friend:

An expert that has 1 follower.

Joined: May 26, 2011
Answers
91
Questions
0
Helped
90897
Points
97

Using the SQL Server Password Unlocker would be the greatest and easiest way to change the password you want, no matter it is admin account or commen user account. It could change it within just 1 min.

Anonymous

Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

Mentor:

An expert who has written 3 tips or uploaded 2 video tips.

Governor:

An expert whose answer got voted for 20 times.

  • Contributor 18 Answers
  • Posted on May 30, 2011
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

Mentor:

An expert who has written 3 tips or uploaded 2 video tips.

Governor:

An expert whose answer got voted for 20 times.

Joined: Sep 08, 2010
Answers
18
Questions
0
Helped
86068
Points
44

Forgot MS SQL Server SA password? SmartKey SQL Password Recovery is a professional MS SQL Server password recovery utility that can easily help to reset lost or forgotten MS SQL Server SA password in minutes without data loss.No matter how long and complex your SA passwords are, SQL Password Recovery can 100% guaranteed to instantly reset user and administrator Passwords for Microsoft SQL Server 2000/2005/2008

Anonymous

Level 2:

An expert who has achieved level 2 by getting 100 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Guru:

An expert who has written 7 tips or uploaded 3 video tips

  • Expert 241 Answers
  • Posted on Sep 16, 2010
Anonymous
Expert
Level 2:

An expert who has achieved level 2 by getting 100 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Guru:

An expert who has written 7 tips or uploaded 3 video tips

Joined: Sep 15, 2010
Answers
241
Questions
0
Helped
90921
Points
306

Hi, you can try to use command prompt to reset your lost password. I have used it to reset sql sa password successfully on sql server 2000/2005.
First, open a command prompt (Start -> Run -> cmd)
Then, type the follow commands, and press Enter after each line:
Osql -S yourservername -E
1> EXEC sp_password NULL, 'yourpassword', 'sa'
2> GO
It could help you. And i know a sql server password recovery tool which can easily and instantly reset your sql sa password, you can try it also.

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1helpful
3answers

Forgot SQL Server SA password. How to reset user password to login SQL Server?

When SA password for SQL Server logon forgot, please take SQL Password Genius to install it on computer.

Step 1: Run SQL Password Genius full version and browse Master.mdf file to import into it.

Step 2: Select SA user and click "Reset" button.
After master database file imported into SQL Password Genius, you would see all user in list. SA password is unknown. Select SA account and click "Reset" button.

A new window would pop up, type new password for SA account in it. And click "OK". Instantly, SA password is changed successfully. SA password lists in software screen.

Step 3: Close SQL Password Genius and restart SQL Server Services.

SQL Server services influence SQL password reset on computer. So we stop it before using SQL Password Genius. Now, when you finish SQL SA password reset, restart SQL Server Services to run SQL Server with SA account.

How to Reset SA and Other User Passwords for SQL Server
Not finding what you are looking for?

780 views

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

Brad Brown

Level 3 Expert

19187 Answers

Cindy Wells

Level 3 Expert

6688 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...