Microsoft SharePoint Team Blog
The official blog of the Microsoft SharePoint Product Group

Introduction to Databases


Introduction to Database Creation


Introduction



A database is primarily a group of computer files that each has a name and a location. Just as there are different ways to connect to a server, in the same way, there are different ways to create a database.

To create a new database in Microsoft SQL Server Management Studio, in the Object Explorer, you can right-click the Databases node and click New Database... This would open the New Database dialog box.

Practical Learning: Creating a Login



Make sure you had created a user account named pkatts introduced in Lesson 1.
To launch Microsoft SQL Server, click Start -> (All) Programs -> Microsoft SQL Server 2008 -> SQL Server Management Studio
On the Connect to Server dialog box, make the correct selections and provide the appropriate information, then click Connect
In the Object Explorer, expand the server name if necessary.
Right-click Security, position the mouse on New, and click Login...


Set the owner to ComputerName\pkatts (Windows XP or Vista) or DomainName\pkatts (Windows Server) (you can also click Search to locate the user name)
Click OK




source : http://blogs.msdn.com/sharepoint/default.aspx