# First step login with windows authen mode.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8SDXnXUZEsKpWzO9wnyEZMj5LUoZd4CkhbVYknt7OugsZ8M4c7M7E9Ch4g1-fhPQKRhg65ujLKbfh75FvT0loXjtOvW12ygvk0GwrmYBjpyUywf1b2RxsmSzlx40jmWGkc0h1/s400/sshot-1.png)
1. Right click at "Security => New => Login..."
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIv8gbwlwULM_O889lsqhjk61x4oTxLuiS1cJOKx7_wEjd3xYiXLDQXA_IaEuNhd5EZ36SR4Eq_4PtX7ibfY_RvbEAh6qO7nsVTZGwhYtxwT665HBhPKp8Ra_zcdIrfNrcMIAc/s400/sshot-2.png)
2. At "Select page => General"
- Checked "SQL Server authentication"
- Unchecked "Enforce password policy" for no specify policy
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLDpqRzMzrH5_q1FMuNsN9Q2a1kpg0t5qnQm1WqYts2EtTmplJJKazniYoX7xWAAsnSpaT-6nYQDlPnhvkmmvpgLoYIZBsIYdlyxhmAsFQaOENs0zmH6RUuhH1PRfkO5x-3nn_/s400/sshot-3.png)
3. At "Select page => User Mapping"
- At "User mapped to this login:" select one or more databases
- At "Database role membership for: [database]"
- Checked "db_owner" , "public"
5. Reconnect database with new login
Add:
- if u want to create System admin in Server Roles only checke sysadmin
- this login user can do everything in database server
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgt5j75OdnOwfSZjkTp7LiwkufDXAvEulM_8BW9jEX9gg-Tgox96NyfN4fLhXk9i7b-56O2QsyTjugJCS9scdovvS-4cUn2lMQjLMwaEx1_EMh5qrRTnsGcSfDdAurftIuDfsW8/s400/sshot-1.png)
Notes:
- การไม่บังคับ policy เป็นสิ่งที่ไม่ควรทำ
- แต่ถ้าเราทดสอบระบบบนเครื่องก็ ไม่น่าจะคิดมากนะ
No comments:
Post a Comment