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. Read more

In our life and work, these follows often happen: I’ve forgotten the sa password for SQL Server, what can I do? How to reset or reset the forgotten SQL password? Don’t worry about that, here I will give you some methods to recover it.

Method 1. Reset SQL password from the command line

1. Open a command prompt window by selecting “Start“–>”Run…”, and typing “cmd.exe” in the “Run” dialog box.

Read more

Look, there are so many similar questions:

“How to reset sa password?”

“How to change SQL password without data loss?”

“I’ve forgotten the sa password for SQL Server – what can I do?”

“How to Change SA Password If Forgot or Lost SQL Password?”

…

In fact Read more