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 prompt, type the following command, and then press ENTER:
osql -U sa
This connects you to the local, default instance of MSDE by using the sa account. To connect to a named instance installed on your computer type:
osql -U sa -S servername\instancename
You are now at the following prompt:
Password:...
How to reset 'sa' password if SQL Password is lost/forgotten/unknown?
First off, you can log in as any SSO role user and have them
reset the 'sa' password for you.
Being life and life being not always so simple we may not always have an SSO role handy (or configured)
So, we resort to the following:
- Edit the ‘runserver' file. By default it's in the $SYBASE_HOME/install directory
- Add "-psa" (for password 'sa') to the end of the command line. (I have noticed that this DOES NOT work in windows unless it's the FIRST param on the command line)
- Save file and reboot server. You ‘may' have to use Unix ‘kill' or Windows ‘End Task' but I suggest that as a last resort.
...
How to change your system administration password if you forget your SQL password?
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?"
...
...
