November 21, 2024

How to create local database in sql server?




First Requirement

Microsoft SQL Server. If in your system not installed, go to the official site and download Microsoft SQL Server and install.

1 : Go to Start Button type SQL or SQL Server in search box.

2 : You get a option for Microsoft SQL Server Management Studio.

3 : Click on that option to open the SQL Management Studio.

4 : In below image select server name browse for more option and click on Connect Button.

5 : In this image select database engine name after selected database engine name click on OK button.

6 : Below image is saying click on connect button.

7 : Here right click on Database, select new database.

8 : Write database name, I’m giving database name ShashiTest for testing purpose, after that click on OK button.

8 : Here, If database name is not showing then select Database and click on top green color refresh Button.

9 : Now you can see your local database name in below image.

So, this was step wise process for How to create local database in SQL Server.




Leave a Reply

Your email address will not be published. Required fields are marked *