Monday, 8. March 2010
One day, you found that you failed to log in windows system, your may lose windows password. What do you do under that situation? Reinstalling the system or anything else? After reading the following contents, you will find the best way to recover or reset windows login passwords when you forget windows password. Let’s take windows 7 as an example.
Read more
Monday, 4. January 2010
Life is so busy that we often forget the passwords like windows, our FDF, office, Outlook password, Internet password and so on. What should we do when we locked out? How to unlock the passwords and get there with the easiest way? Today, I recommend a very good tool Password Recovery Bundle for you. Read more
Tuesday, 15. December 2009
You have a variety of options for updating the SQL Server Agent password on the clients. The method you specify depends on the tools available on the client computer.
If the SQL Server Enterprise Manager is available on the client computer, you can change the sa password directly. For details, follow the procedure in Changing sa Password on the Server. Read more
Tuesday, 15. December 2009
If you happen to forget your SQL Server password for ’sa’ account, then here’s a simple query to help you reset it:
| ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N’MyNewPassword’ MUST_CHANGE
GO |
In Case you remember your Old Password and want to change ’sa’ password, use this query:
| ALTER LOGIN [sa] WITH PASSWORD = N’MyNewPassword’ OLD_PASSWORD = ‘MyOldPassword’;
GO |
Tuesday, 15. December 2009
1.Open a command prompt window by selecting “Start”–>”Run…”, and typing “cmd.exe” in the “Run” dialog box.
2.Change to the directory in which the MSSQL or MSDE utilities are stored (this is usually C:MSDEbinn, C:Program FilesMSSQLbinn, etc.).
3.Type the following command where <newpassword> is the password you have chosen:
| osql -U sa -P ”" -Q ”sp_password NULL,<newpassword>,sa” |
Monday, 14. December 2009
A few days ago, I had a painful exprience that I lost sa password on my MS SQL Server database, and I almost took the whole weekend to look for some efficient SA password recovery solutions. I asked friends, searched on Internet and even bought some books… Fortunately, I finally got MS SQL Server Password Unlocker and it instantly changed the SA password but no data loss. Besides, I also got a couple of good “recover SA password” solutions in order 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 Reset SA Password
The most direct, efficient and fastest way to reset SA password is to take use of the third part utility – MS SQL Server Password Unlocker. Just two steps:
Step 1: Access to master.mdf file, which is default at C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf
Read more
Wednesday, 9. December 2009
For protecting ours sensitive information, it is necessary to disable Internet Explorer password caching.
To disable password caching, follow these steps:
Read more