How to Create an SQL Server Database

By Techwalla Computers Editor

An SQL server database comes into play when large numbers of concurrent connections need to be made or when the ability to have the capacity for large numbers of records is necessary. To create an SQL server database, you must install Microsoft SQL Server on the system and use SQL Server Management Studio to create the database.

Step 1

Click on Start in the lower left-hand corner of your desktop screen. Then select All Programs, the Microsoft SQL Server 2005 group link and the SQL Server Management Studio.

Step 2

Accept the default settings by clicking on the Connect button when the Connect to Server dialog box opens.

Step 3

Put the mouse cursor over the Databases folder icon in the list in the Object Explorer window after completing the connection to the server.

Step 4

Right click on the icon and select New Database from the list that appears.

Step 5

Enter the database name in the text box at the top of the form where the cursor is blinking. The name of the database can be any legal name that the system will accept.

Step 6

Add more files to the database, if needed, by clicking on the Add button toward the bottom of the form.

Step 7

Hit the OK button at the bottom of the form. The new database name will appear in the list of available databases on the server.

Tips & Warnings

  • Add a user name and password to protect your SQL server.