In this SQL Server tutorial, you will learn about MSSQL create database. The database is a collection of information that we can view, change, and delete. This tutorial explains step by step how to create a database using MSSQL.
How to create a database in SQL Server 2019
To create a database in SQL Server 2019, follow the below steps.
1. As a 1st and foremost step, type SQL server management studio in the search bar of Windows, and the below image will appear.
2. Now, the SQL Server page will appear. Select Windows Authentication and click Connect.
3. Once you click Connect, then under the server name, you will see the list of options.
4. Here, right-click the Databases and click Create New Database.
5. Now, give the Database name and click OK. [For example, I have given SQLDB].
6. Click the Options page, and in the Collation option, choose SQL_Latin1_General_CP1_C1_AS and click OK.
7. Click Logins by expanding the Security options. Right-click on Logins and click New Login..
8. Now, the Login—New page will appear. Here, provide the Login name and select SQL Server Authentication. Provide the password and confirm it. Provide the Default database you created recently and click OK.
9. In the Object Explorer panel, expand Databases > <dbname> > Security > Users. Select Users from the option.
10. Right-click Users and select New User.
11. In all the fields, give the same name to the User name, Login name, and Default schema as you gave for the login name, which is imsdbusr.
12. Now, on the left side, under Select a page, Click Membership and tickmark the checkbox db_owner.
13. Here, click Schema and right-click New Schema by expanding Security. Give it the same name as imsdbusr.
14. Give the same name imsdbusr in the Schema name and Schema owner, and click OK.
You have created the database successfully. Now, close the management studio.
Conclusion
I hope this is the easiest and best method to connect to the database in MS SQL Server. Also, I explained how to create schema and create new users as well. Try from your side by following each and every step.
You may like to read:
I am Bijay having more than 15 years of experience in the Software Industry. During this time, I have worked on MariaDB and used it in a lot of projects. Most of our readers are from the United States, Canada, United Kingdom, Australia, New Zealand, etc.
Want to learn MariaDB? Check out all the articles and tutorials that I wrote on MariaDB. Also, I am a Microsoft MVP.
