Question about Computers & Internet

8 Answers

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.

Posted by on

Ad

8 Answers

  • 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

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.

Posted on Dec 01, 2016

Ad
  • 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
  • 43 Answers

- 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

Posted on May 21, 2016

Ad
  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

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.

Posted on Jun 12, 2014

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that has over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 14 Answers

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

Posted on Jun 21, 2012

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 3 Answers

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!

Posted on Mar 07, 2012

  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that got 5 achievements.

    Filmmaker:

    Uploaded 5 video answers.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Contributor
  • 91 Answers

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.

Posted on May 31, 2011

  • 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

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

Posted on May 30, 2011

  • 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

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.

Posted on Sep 16, 2010

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

Tip

Deal with Forgotten SQL SA Password


Here is an essay which will introduce something about SQL Server password such as the policy of what kind of the SQL SA password should be, and also how to reset the <a href="http://www.passwordunlocker.com/knowledge/how-to-reset-sa-password-or-other-sql-password.html">SQL password</a>.<br /> <br />I. Policy of SQL Server password<br /> <br />Password Complexity<br /> <br />Password complexity policies are designed to deter brute force attacks by increasing the number of possible passwords. When password complexity policy is enforced, new passwords must meet the following guidelines:<br /> <br />1. The password does not contain all or part of the account name of the user. Part of an account name is defined as three or more consecutive alphanumeric characters delimited on both ends by white space such as space, tab, and return, and any of the following characters: comma (,), period (.), hyphen (-), underscore (_), or number sign (#).<br /> <br />2. The password is at least eight characters long.<br /> <br />3. The password contains characters from three of the following four categories:<br /> <br />* Latin uppercase letters (A through Z)<br /> <br />* Latin lowercase letters (a through z)<br /> <br />* Base 10 digits (0 through 9)<br /> <br />* Non-alphanumeric characters such as: exclamation point (!), dollar sign ($), number sign (#), or percent (%).<br /> <br />Passwords can be up to 128 characters long. You should use passwords that are as long and complex as possible.<br /> <br />II. Reset SQL SA Password<br /> <br />1. Way to change the known sa password to a complex one<br /> <br />Step 1: Run command prompt when you have made sure the SQL has been connected.<br /> <br />Step 2: Type in the following command and then press Enter<br /> osql -U sa<br /> <br />Step 3: Type in the command as the following shows to change the password and then press Enter<br /> <br />Sp_password @old = null, @new = 'complexpwd', @loginame='sa'<br /> go<br /> <br />2. Use MS SQL Server Password Unlocker to reset the unknown sa password<br /> <br />As we suggested in the policy of the SQL SA password, the password should be as long and complex as possible then it would be easy to lead a serious problem -- forget SQL password. So here we also need to know some convenient tool to reset the forgotten <a href="http://www.passwordunlocker.com/knowledge/change-sql-server-password.html">SQL Server password</a>. And following is an efficient tool which you can use -- MS SQL Server Password Unlocker.<br /> <br />MS SQL Server Password Unlocker supports MS SQL Server and MS SQL Server Express 2000/2005/2008 SQL password recovery. Also it is known for the clear and interactive of the design. You can use this tool to reset your SQL password instantly within a few steps.<br /> <br />Step 1: <a href="http://www.passwordunlocker.com/downloads/ms_sql_server_password_unlocker_trial.exe">Download MS SQL Server Password Unlocker</a> on your local PC, install and launch it.<br /> <br />Step 2: Click the Open button to import the file of master.mdf.<br /> <br />Step 3: Select the SA account and then click Change Password button.<br /> <br />Step 4: Enter your new password and click OK. Your SA password will be reset.<br /> <br />You may have a check on the website to see how bright the interface is.Also MS SQL Server Password Unlocker would support you whenever you get any questions about the program as they got the most patient customer service and professional technical supporting.<br /><br />For more info please visit: <a href="http://www.passwordunlocker.com/sql-server-password-recovery.html%20">http://www.passwordunlocker.com/sql-server-password-recovery.html </a><br />

on Nov 27, 2010 | Computers & Internet

Tip

Tricks for Keeping SQL Server Safely


Some simple ways to protect your SQL Server database

1. Using the Microsoft Baseline Security Analyzer (MBSA) to assess the server's security
MBSA is one of a variety of Microsoft products, which can scan unsafe configuration tools. It can be run locally; you can also run through the network.

2. Isolate your server and regularly back up
Physical and logical isolation would form the basis of SQL Server security. Database should be installed within the enterprise network security area, but not directly connected to the Internet. Back up all data regularly and store copies in a safe location outside the site.

3. Assign a strong SA password for a SA account
SA account should always have a strong password, even if Windows is configured to require authentication of the server. This will ensure that the server has been reconfigured in the future as Mixed Mode authentication; it will not appear blank or weak SA.

4. Restrict the permissions SQL Server service
SQL Server 2000 and SQL Server Agent is running as a Windows service. Each service must be associated with a Windows account, and derive from this account security context. SA log in SQL Server allows the user (sometimes including other users) to access the operating system features.

About reset SA password in SQL 2008/2005/2000

To secure our database we would like to choose create an intricate password. But even our selves would forget the SA password in SQL Server 2005/2008 sometimes. So here is a way for you to reset SQL Server 2005 password -- MS SQL Server Password Unlocker, which is a highly A Highly Technical and Safe SQL password 2005 Recovery tool. And following is a few features of the tool.

Features:

* Support SQL Server password recovery for MS SQL Server and MS SQL Server Express 2008/2005/2000

* No need to install MS SQL Server on your PC or lose data, the file master.mdf format is necessary

* Stop and resume MS SQL service automatically if the MS SQL Server on your PC is running

* Reset SQL password with ease no matter how long and complicated the SQL password is

* Easy to use

Feedback:

The most of people who encountered with SQL 2005 password losing problems are getting back to their SQL account now. We can also feel that ease and the hilarious mood when a hard nut has been cracked. Hope this MS SQL Server Password Unlocker would help more people and get their trouble erased.

on Nov 12, 2010 | Computers & Internet

Tip

SQL 2008 SA Password Reset


How to reset sa password in SQL Server 2008 when forgot the sa password?

Many time, This problem comes, they have setup SQL 2008 or SQL 2008 R2 for development or QA environment, but they don't know the login sa password by which they can connect to server. In SQL Server 2005, SQL used to fixed group sysadmin with the server role BUILTINAdministrators, that is to say, all local NT administrator automatically add a SQL Server system administrator. But since 2008 Windows BUILTINAdministrators group is not included by default in the sysadmin server role in SQL Server.

So, follow the steps mentioned to reset SQL 2008 password for SA account if no BUILTINAdministrators.

Step 1. Download and install MS SQL Server Password Unlocker.

Step 2. Run MS SQL Server Password Unlocker, click Open, import the master.mdf file. All the user names of your SQL Server will be displayed.

Step 3. Select an SQL account, such as 'SA', click Change Password button.

Step 4. Type a new password, and then click OK.

The new password has been set for your SA account, now you can login
SQL Server with the new password.

Currently SQL Server 2008 still supports two types validation and authentication for access link to resources database, Windows authentication mode and SQL Server and Windows authentication mode which also known as mixed mode. Both of these authentication methods provide access to SQL Server 2008 and its resources.

The Mixed Mode - SQL Server and Windows Authentication Mode

SQL Server and Windows Authentication Mode uses either Active Directory user accounts or SQL Server accounts when validating access to SQL Server. SQL Server 2005 introduces a new way, the policy of the password and account lockout the policy session of SQL Server by using SQL Server implement authentication. SQL Server 2008 also to do so. The policy of SQL Server that can be used include password complexity, password expiration and account lockout. This feature is not available in SQL Server 2000 and becomes a major security risk for most organizations and database administrators. In essence, this weakness has contributed to the Windows authentication set as best practice for the management of authentication in the past. Today, SQL Server and Windows authentication mode may be able to successfully compete with the Windows Authentication Mode.

on Oct 26, 2010 | Computers & Internet

3 Answers

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

Jun 27, 2014 | Microsoft SQL Server 2005 Enterprise...

Tip

How to recover sql 2000 sa password


Microsoft SQL Server 2000 is a full-featured relational database management system that offers a variety of administrative tools to ease the burdens of database development, maintenance and administration. It operates in one of two authentication modes: Windows Authentication Mode (the default) or Mixed Mode.

When you install the SQL Server 2000, you can log in the server with Windows Authentication and SQL Server Authentication if you select mixed mode authentication. If you select Windows Authentication, you cannot assign a sa password during installation. However, you should set the sa password after installation.

It is very easy for one to set sa password in SQL 2000. Just follow the below steps:

* 1. Expand a server group, and then expand a server.
* 2. Expand Security, and then click Logins.
* 3. In the details pane, right-click SA, and then click Properties.
* 4. In the Password box, type the new password.

The type of client connections determines the choice of security mode. If all of the incoming clients support trusted connections, you can use Windows Authentication Mode. If some clients do not support trusted connections, you can select Mixed Mode.

If you forget the sa password, you will need to use MS SQL Server Password Unlocker to reset sa password SQL 2000. MS SQL Server Password Unlocker is easy yet powerful SQL Server password reset software for you to reset SQL password, including reset SA password and other user passwords. It provides you an easy and safe way to reset SQL Server password for Microsoft SQL Server 2000/2005/2008 in a minute. No need for you to reinstall MS SQL Server on your PC. The file in master.mdf format is enough for you to recover sa password SQL 2000.

Steps to reset sql password 2000 for sa as follows:
* 1. Download and install MS SQL Server Password Unlocker.
* 2. Click the application icon to run it.
* 3. Click Open to import your master.mdf file. All the user names of your MS SQL Server will be displayed.
* 4. Select sa account, click Change password button to reset sa password.
* 5. Type a new password, and then click OK to finish your operation.

Note: This method to reset sa password in sql server 2000 is usually applied when you cannot login SQL Server 2000 by Windows Authentication wile you forget system administrator login password.

More information about sa password:

According to Microsoft, System administrator (sa) is a special login provided for backward compatibility. By default, it is assigned to the sysadmin fixed server role and cannot be changed. Although sa is a built-in administrator login, do not use it routinely. Instead, make system administrators members of the sysadmin fixed server role, and have them log on using their own logins. Use sa only when there is no other way to log in to an instance of Microsoft SQL Server.

on Oct 19, 2010 | Computers & Internet

Tip

Reset sql sa password directly and efficiently


A few days ago, I had a painful experience that I lost SA password on my MS SQL Server database, and I almost took the whole weekend to look for an efficient way to reset SA password. I asked friends, searched on Internet and even bought some book.... Fortunately, I finally got a SQL server password recovery software and it instantly reset SA password without data loss. And I also got a couple of good solutions for sql sa password reset to save your weekend in case you have lost or forgot MS SQL Server passwords (SA password!).



Option 1 : Use MS SQL Server Password Unlocker to Recover/Reset SA Password

The most direct, efficient way to reset SA password is to take use of the third part utility - SQL server password recovery software. Just two steps:

Step 1: Access to master.mdf file, which is default at C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf

Step 2: Select SA password and reset SA password
So, Reset SA password successfully!



Option 2 : Recover or Reset SA Password with Other SQL Server Login
If there is any other SQL Server Login that is a member of sysadmin role, you can log in using that account and reset SA password of SQL Server. Reset sql sa password as described here :

SQL SERVER - Reset Password of SA Login Using Management Studio.

Login into SQL Server using Windows Authentication.

In Object Explorer, open Security folder, open Logins folder. Right Click on
SA account and go to Properties.

Reset SA password, and confirm it. Click OK.

Make sure to restart the SQL Server and all its services and test new password by log into system using SA login and new password.



Option 3 : Recover or Reset SA Password with Windows Login that is a member of Windows Admin Group

If there is any other Windows Login that is a member of Windows Admin Group, log in using that account. Start SQL Server in Single User Mode as described followings :

SQL SERVER - Start SQL Server Instance in Single User Mode.

There are certain situation when user wants to start SQL Server Engine in "single user" mode from the start up.

To start SQL Server in single user mode is very simple procedure as displayed below.

Go to SQL Server Configuration Manager and click on SQL Server 2005 Services. Click on desired SQL Server instance and right click go to properties. On the Advance table enter param '-m;' before existing params in Startup Parameters box.

Make sure that you entered semi-comma after -m. Once that is completed, restart SQL Server services to take this in effect. Once this is done, now you will be only able to connect SQL Server using sqlcmd.

on Oct 05, 2010 | Computers & Internet

Tip

4 Methods to Change MS SQL Server Password


Have you ever forgot or lost your MS SQL Server password? Did you reinstall MS SQL Server or change SQL Server Password by some ways at that time? I once forgot my MS SQL Server password and I reinstalled My MS SQL at last as I failed to find some good methods to solve the problem. What annoying and terrible experience it is! In order to avoid reinstalling SQL Server for a second time due to the same reason, so I collect some methods to change SQL Server password for sa account.

Method 1: Use Command Prompt to Change SQL Server Password


Step 1. Open a command prompt (Start -> Run -> cmd)
Step 2. Type the follow commands, and press Enter after each line:
Osql –S yourservername –E
1> EXEC sp_password NULL, ’yourpassword’, ’sa’
2> GO
The yourservername is the name of your server, yourpassword is the new sql sa password.
The command line 1> also can be changed to other command, the model is EXEC sp_password ‘oldpassword’, ‘newpassword’, ‘sqlaccount’.


Method 2: Use the Query Windows in Management Studio to Change MS SQL Server Password

Step 1. Open SQL Server Management Studio
Step 2. Open a new query
Step 3. Type the follow commands and excute:
GO
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'NewPassword' MUST_CHANGE
GO
The NewPassword is set for your SQL Server sa account.


Method 3: Change SQLServer Password by Windows Authentication

If Builtin/Administrator is present in SQL Server, you can login with an ID which is member of Administrators group and change sa password in SQL Server. Just do as follows:
1. Login into SQL server using Windows Authentication.
2. In Object Explorer, open Security folder, open Logins folder. Right Click on sa account and go to Properties.
3. Type a new SQL sa password, and confirm it. Click OK to finish.
After restarting SQL Server and all its servers, you can log into SQL Server by sa login with new SQL sa password.


Method 4: Change MS SQL Server Password with Third Party Software

In addition to the methods above, you can aslo choose some SQL Server password recovery tool to change SQL Server password. MS SQL Server Password Unlocker is one of the good MS SQL passwrod reset tools which can help you change SQL Server password in a few seconds. It allows you to chage MS SQL password on SQL Server and Express 2000/2005/2008.

Following is a guide for you to change MS SQL password with MS SQL Server Password Unlocker.
Step 1.Download and install MS SQL Server Password Unlocker.
Step 2. Run MS SQL Server Password Unlocker, click Open, import your master.mdf file. All the user names of your MS SQL Server will be displayed.
Step 3. 3. Select an SQL account, click Change password button.
Step 4. Type a new password, and then click OK.
This SQL account password has been reset. You can login with it.

Well, the four solutions are the easy-to-use MS SQL Server Password Reset ways.

on Aug 10, 2010 | Computers & Internet

Tip

The easiest way to reset sql sa password.


无标题文档 The easiest way to reset sql sa password. One of my friends complained that: I am not a sql db manager by any means but I've been asked to reset sa password for a sql 2005 server. My concern is ...will changing this password have any effect on applications that use sql 2005. They use Micro CRM 3.0, and I don't want to disrupt their service. The reason they want to reset the password is because they recently bought a new accounting package that will tie into CRM, and the technicians are requesting the password to complete the install.
In fact, MS SQL Server Password Unlocker can reset sql password in no snap! Just install the sa password recovery program on the computer where the sql master.mdf is saved. MS SQL Server Password Unlocker accesses to the master.mdf file directly and lists all the users to the database. For accessing the master.mdf smoothly, the password recovery program detects and stops the running SQL Services automatically

on Mar 17, 2010 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

716 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

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

Answer questions

Manuals & User Guides

Loading...