To assign the sa password on a newly installed serverWhen you install Microsoft® SQL Server™, SQL Server Setup does not assign a password to the sa login. You can assign a password to sa after a server is installed.
You should assign an sa password if the server security is set for Mixed Mode. If the server is set for Windows NT Authentication Mode, an sa password is not necessary because sa is a SQL Server login.
Important Do not forget the sa password. If you cannot provide the correct sa password, you must reinstall SQL Server.
The first time you log in to a newly installed SQL Server installation, use sa as your login identification and no password. After you log in, change the sa password to prevent other users from using the sa permissions.
Note The server must be registered to use SQL Server Enterprise Manager before the sa password can be changed.
To assign the sa password on a newly installed server
