MS SQL Server Management Studio Guide

Login:

• Server type - default
• server name - what ever server name created
• authentication -
• Windows authentication (currently logged in windows user, can only work if such user has been created in SQL)
• SQL server authentication(created sql user)

Create User :

• Login with admin account
• Expand Security, right click login ->  new login ....
• specify whether its SQL server authentication or Windows authentication(need a user from active directory)
• create user name and password
• server role -> public, sysadmin, serveradmin(if wish to create user and database)
• user mapping -> can map to one or multiple database, and assign database role, such as db_datareader for read tables, db_datawrite for write into tables. For user to be able to create table, need db_owner permission. and public permission

Create Database:

• Right click database -> new database