Creating DataBase in Microsoft SQL Server

Click on Start Button in Windows and Select SQL Server Management Studio.

 

Give the Server Name (Machine Name) 

Select Windows Authentication :

User Name, Password is not required, they will be disabled, SQL Server starts directly using User Name, Password supplied while log-in to Windows.

SQL Server Authentication :  

User Name, Password will be enabled, SQL Server asks for User Name and Password, type the user name and password specified while installing the SQL Server Software.

Using user name and password of OS we can login or user name and password available inside SQL Server.

 After doing any one operation click on Connect

 

Now it will connect to SQL Server and the following screen will appear.

 

Now to create Database then right click on Database -> Click on New Database ->Type database name ->Click on Ok.