| ASP.NET Web Matrix simplifies the
development of ASP.NET database applications by including support for
Microsoft SQL Server and MSDE (a free SQL Server compatible
database engine) database administration from within the ASP.NET Web Matrix
development environment.
MSDE is available for installation as a free stand-alone product
on www.asp.net or with any of the
following Microsoft products:
- .NET Framework SDK
- Office XP Professional
- Visio 2000
Designed to run in the background, MSDE does not have its own user
interface (UI) or tools. You interact with MSDE through the ASP.NET
Web Matrix development environment.
In this walkthrough, you will connect to a local installation of MSDE.
- Click the Data tab in the Workspace window.
Note If you have SQL components installed locally, ASP.NET Web
Matrix will display an empty data workspace.
Note If you do not have SQL components installed locally,
ASP.NET Web Matrix will display an informational message and a link that
you can click to download and install a free copy of MSDE. Download and
install MSDE, if necessary.
- Click the New Connection button on the Data window
toolbar.
- You will see the Connect to Database dialog box appear.
- Type localhost in the Server box (default).
- Click the Windows authentication radio button.
Note If your SQL Server configuration requires only SQL Server
authentication, click the SQL Server authentication radio button
and type valid SQL Server credentials in the User name and
Password boxes.
Next Step >> |
