How to Create a SQL Server Database: 7 Steps

Table of contents:

How to Create a SQL Server Database: 7 Steps
How to Create a SQL Server Database: 7 Steps
Anonim

Creating a simple SQL Server database is a very simple and intuitive process. This tutorial guides you through the process, but does not show the code necessary for integrating and using the DB within your program or application. Let's see it together.

Steps

Create a SQL Server Database Step 1
Create a SQL Server Database Step 1

Step 1. Launch 'Microsoft Visual Studio'

Create a SQL Server Database Step 2
Create a SQL Server Database Step 2

Step 2. Go to the 'View' menu and select the 'Server Explorer' item

Create a SQL Server Database Step 3
Create a SQL Server Database Step 3

Step 3. Select the 'Data Connections' item with the right mouse button and choose the 'Create new SQL Server database' option

Create a SQL Server Database Step 4
Create a SQL Server Database Step 4

Step 4. If you are using SQL Server Express, in the 'Server Name' field, type '

SQLEXPRESS '(without quotes).

If not, use whatever name you want.

Create a SQL Server Database Step 5
Create a SQL Server Database Step 5

Step 5. Make sure the 'Use Windows NT Authentication' radio button is selected

Recommended: