Setup Local Database In SQL Server

In this blog, you will learn how to setup local instance in sql server management studio.

Requirements

Microsoft SQL Server. If not installed, go to the official site and download and install the setup file.

STEP 1

1. Go to Start and search for Microsoft SQL Server.
2. You can find an option for Microsoft SQL Server Management Studio.
3. Click on it to open the SQL Management Studio.
   
   

STEP 2

1. To create a local database, you need a Server first.
2. While installing the SQL Server, you would have set a user which will act as the Server.
3. Select the Server and also ensure that the credentials you are providing in the authentication processes are right.
4. After entering all the details, click on the "Connect" button.
5. If the connection fails, check if the Server is in running state.
6. If it is not running, just right click on the Local Sever and click on the Start option.
7. You can find the Server in the Local Server option of the Registered Servers.
8. To view the registered servers, go to VIEW -> REGISTERED SERVERS.
   
   

STEP 3

1. Now, you are connected to the Server, so can you create a database.
2. In the Object Explorer, find the Databases folder.
3. Simply right click on it and select new database option.
4. This will initiate the new database creation.
   
   

Step 4

1. You will see a window when clicked on the new database option.There, you can add the new database.
2. You can add more than one database on the same Server.
3. Click on the "Add" button to add a new database.
4. If you want to remove any database, just click on the "Remove" button.
5. Once you are finished with adding your required number of databases, click on the OK button.
   
   

STEP 5

1. Now, you can see a new database appearing in the database menu in the Object Explorer. You can now use this database for your local storage.
   
   

So, this was the process for local database creation using MS SQL 

In my next write-up, I will explain the steps for writing queries and creating tables. Thank you.