How to create SQL password?

[UkRaiNeR]

How to create SQL password? i know that u can create a pass when u install SQL but, i forgot so it possible to create a password.. can i change some how that i dont need to reinstall ... i dont wona to delete my servers database, please help me.. thx

[MentaL]

[-RooK-]

open if you studio express and do this;

1) expand "security"
2) expand "logins"
3) right click on acct "sa" then click properties
4) type in the password you want in the 2 pw boxes
5) be sure "enfore password policy" box is checked off
6) change "defualt database" to "GunzDB"
7) click ok

[UkRaiNeR]

but i wona to create a password when i trying to connected to SQL not only a GunzDB, when i open the SQL, windows popo up and say Connect to the sever, it just has a username but no pass and i connect easly :/ can i make 1?

[-RooK-]

Creating the password the way i told you is teh same thing, when you first open studio express, go to sql server authentification then it will show a login box and password box, you use the sa//password to login, same thing