While installing SQL Server 2000 on my Windows 2000 Advanced Server, i choose Windows Authentication mode, so i was not able to enter a password for sa account. And after installation, in Enterprise Manager i could still see sa account under logins but the account has a password.
So my question is what is the default password for sa account when we choose Windows Authentication mode and is it possible to change the mode from windows Authentication to Mixed Authentication mode after installation, with out re-installaing SQL Server 2000.
You will be able to change from Windows Authentication to Mixed Authentication mode by following these steps
1. Open EM
2. Right click on server name ... click properties.
3. In window that opens up ... select Security tab
4. Change authentication from "windows only" to "sql server and windows" .
I believe your default password for SA when you do this will be blank ... so make sure you change it asap.
but i belive that the default password is not blank, bcoz when i choosed windows Authentication mode, the sa login was created and when i right clicked the login and choosed properties, it has 10 * in the password field. So the password is made of 10 charcters.
So i want to what is that password. In oracle we have default username and password as Scott and tiger. Similarly what is the default password for sa login.