yourfirstserver.comThursday, 24 May 2012
Find Us on : RSS/Feed Facebook Twitter

How to reset sa password in MS SQL Server ?

How to reset sa password in MS SQL Server ?

The sa account has full rights in the MS SQL Sever environment. When you install the MS SQL Server program, the sa account is created and sa password is default blank (NULL). You can also change the blank sa password to a strong one when the setup program is running.

How to verify if the SA password is blank

1 On the computer that is hosting the instance of MSDE to which you are connecting, open a command prompt window.

2 At the command

...

How to Change SA Password or Other MS SQL Server Passwords?

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

...

Oracle 11g’s Strong Verifier and Case Sensitive Password

As an Oracle DBA, you probably have heard a lot about the new security features in Oracle 11G such as database vault, audit vault, strong verifier, enhanced ASO, etc. But with a busy schedule, how do you find the time to study all the topics in depth? Are all of them going to affect your daily DBA operations? What should you know first and foremost? Of course, depending on the particular database you are administering, you will have your unique need. But as a rule of thumb, what tends to affect you the most is almost never those cool new features. The reason is simple: if you

...