An exploration of the joys and frustrations when programming with Microsoft .NET. Taken with the perspective of working in a faith-based ministry, striving to release children from poverty in Jesus' name.

NetTiers and SCSF, Part 2

Posted 5.18.07 in Uncategorized

Carrying on from the last post… I was stepping through setting up a virtual machine image to work with, and realized that I forgot to mention one important requirement for all this - a database!

SQL Server Express works great. I grab the version with Reporting Services, but that is more out of habit than anything else. It is much easier in the long run to have the SQL Express Management Studio as well. The installer is available for download in the same location as the SQL Express files. You should also download the AdventureWorks database, to have a convenient starting point.

Database Installation

After downloading the SQL Server Express package, run the installer. Take all the defaults, and it should be a quick install. One thing to watch for: there is an option to make SQL Express the default instance or to create a new instance. As long as you do not have any SQL instances installed, it is easier to make this the default instance.

Next, run the installer for the AdventureWorks database. The installer should detect the Data directory that was just created by SQL Express. Use this location and install the database.

sql_connect_login.png

The database is installed (copied to disk), but is not ready to use yet. To make it ready, open the SQL Management Studio. At the database connection screen, enter (local) for the server name and use Windows Authentication to connect to the database.

Once connected, right-click the Databases folder under the server. Choose “Attach…” from the menu. In the Attach Databases window, click the “Add…” button. A window should open showing the databases in the default data directory. Select the AdventureWorks_Data.mdf database and press OK. Press the OK button on the Attach Databases window, and the database should be successfully set up with the SQL Server instance.

attach_aw.png

Finishing Installation

Just a few more pieces to install, and we’ll be ready to move forward. Find the ZIP files for NUnitForms and RhinoMocks. Extract each one into an easy-to-find location. I put mine in the C:\Tools folder, each in their own subfolder.

Locate the installer file for NUnit. Run the installer, taking all the defaults.

Open the ZIP file for TestDriven.NET and run the installer contained inside it. Take all the defaults.

Finally! Everything is installed and ready to go.

Next time: Setting up a Visual Studio project, and getting everything ready to go.

Leave a Reply

About

This is a collection of the thoughts and ideas of a software developer and solutions architect with Compassion International. Topics of interest include software architecture, design patterns, software factories, team dynamics and the art of computer programming.

Meet Kenneth Scott

Categories

  • No categories

For "All flesh is like grass and all its glory like the flower of grass. The grass withers, and the flower falls, but the word of the Lord remains forever." And this word is the good news that was preached to you. (1 Peter 1:24-25)

Copyright © 2007 – 2008, Kenneth Scott.