How To: Manually create new SQL Server Database

This article describes how to create new SQL Server Database.

Step-by-step guide

The steps are as follows:

1. Open SQL Server. This opens the Microsoft SQL Server Management Studio window.
   
   
2. After it opens, provide the required credentials in the Connect to Server window.
   1. Fill in the Server Type and the Server Name fields.
   2. In the Authentication drop-down, select SQL Server Authentication option. This will activate the Login and Password fields. Provide valid login ID and password and click on the Connect button. 
      
      
3. After the authentication process is over, go to the Object Explorer panel on the left hand side and right-click on the Databases folder. From the drop-down list, select New Database option. This opens the New Database window.
   
   1. Provide a new database name in the Database name field. Click OK.
      
      
4. Once again go to the Object Explorer panel on the left hand side. This time, click and expand the Security folder. From there, right click on the Login folder. Select New Login. This opens the Login - New window.
   
   1. Provide a new login name in the Login name field. Click OK.
   2. Next, select SQL Server Authentication.
   3. Now type in a password in the Password field. Re-write the same password in the Confirm Password field.
   4. Remove selection of the Enforce password policy option.
   5. Click OK.
      
      
5. In the Login folder, double click and open the newly created login. This will open the Login Properties - <Name of the newly created login> window.
   1. Go to the Select a page panel on the left hand side and click on the User Mapping option.
   2. Select  the newly created database from the list.
   3. Now go to the Database role membership for: <New database name> section and select the db_owner option.
   4. Click OK.
      
      
6. Click on the Close button on the top right hand corner of the screen to close the Microsoft SQL Server Management Studio window.