Hi, how i can create a basic database for my lab?

Well, see below!

Start SQL Server Managment Studio

Connect to your DB server


Click on DataBase, then right click and choose New Database…image-03

Enter a database name and click on Ok.image-04

Click on Security, login, then right click and choose New Login…image-05

Choose SQL Server authentication, add a login name and password. Uncheck User must change password at next login.

Choose the default database and click on User Mapping.image-07

Choose your DataBase and add db_owner rights. Click on Ok.image-07Hope it’s help.