Creating your First SQL Server Database in SQL Server Management Studio

Welcome! to my article on Creating your first SQL Server Database in SQL Server Management Studio.

Prerequisites:

• No previous experience with SQL Server is required! Yay!!
• Installed version of SQL Server 2005,2008 or 2012 with Management Tools
  
• Access to a test / dev environment for creating these databases
• The passion to learn

Now let us begin

1. Launch SQL Server Management Studio by clicking on Start –>All Programs –> Microsoft SQL Server 2x(2005/2008/2012) –> SQL Server Management Studio

2. You will now be presented with the following dialog.

3. In the login dialog, under ServerName: Please enter your Server’s Name or IP Address

4. Now under Authentication: You may choose Windows Authentication or SQL Server Authentication

Attention: If Windows Authentication is enabled and not Mixed Authentication, you cannot login as a SQL Server user.

Now, once you have logged in you will be presented with the following Environment as shown below.

Creating the Database – SQLPlanet

1. Right Click on the Databases Folder –> Choose New Database

2. You will be presented with the following screen
Under Database Name: Enter SQLPlanet) Leave the remaining as Defaults, we will cover these options in subsequent article series

3. Click on the OK button to complete the Database creation process

4. You should now see the database created as shown below

Success!! – Congratulations on creating your very first SQL Server Database using SQL Server Management Studio

Do let me know your feedback. You can e-mail me anil dot mahadev at gmail.com with
the Subject Line indicating: Creating your first SQL Server Database in SQL Server Management Studio.