Filter
Top Products
184 Microsoft Visual Studio 2010: A Beginner’s Guide
To create a database, right-click Data Connections in Server Explorer, and select
Create New SQL Server Database. This will show the Create New SQL Server Database
window, shown in Figure 7-2.
In Figure 7-2, the server name is .\sqlexpress. The dot before the backslash represents
the current machine name, and the sqlexpress is the name for the SQL Server Express
database. Server names will vary, depending on the location of the server and the name
given to the database server instance. For example, if you were deploying an application to
a shared Web hosting site, the server name would look something like sql02.somedomain.
com, which is established by the hosting provider you are using.
Your authentication options include Windows and SQL Server. Here, I’m choosing
Windows authentication because it’s the simplest option. The database created here is
local, but you might have a database already created on a server at another location.
The database on another server might have a SQL login, which is another method of
authentication.
After adding the database name, click OK to create the database. As shown in Figure 7-2,
we’ve called this database MyShop, representing an application that supports customers who
order products from a store. You’ll see the new database under Data Connections in Server
Explorer, similar to what you see in Figure 7-1. Now you’re ready to add tables.
Figure 7-2 Create New SQL Server Database