SQL Server 2005 Configuration
You will need to download and unzip the default MS SQL database:
http://www.hannonhill.com/downloads/cascade/mssql.zip
1. Download and extract URL zip
2. Move the unzipped file cascade.mdf to the SQL Server data folder. For example: C:\Program Files\Microsoft SQL Serever\MSSQL\DATA\cascade.mdf
3. Open SQL Server management studio.
4. In SQL Server Management Studio Object Explorer, connect to an instance of the Microsoft SL Server Database Engine and then expand that instance.
5. Right-click Databases, point to Tasks, and then click Attach. The Attach Databases dialog box appears.
6. To specify the database to be attached, click Add, and in the Locate Database Files dialog box, select the disk drive where the database resides and expand the directory tree to find and select the cascade.mdf file.
7. Optionally, to specify a different name for the database to attach as, enter the name in the Attach as column of the Attach database dialog box.
8. Optionally, change the owner of the database by selecting a different entry in the Owner column.
9. In the Database Details field, select cascade_Log.LDF and click Remove.
10. When you are ready to attach the database, click OK.
SQL Server authentication must also be enabled. To do this in Management Studio:
1. Right-click on the Server in the Object Explorer and select Properties
2. Click on the Security tab.
3. Make sure authentication is set to "SQL Server and Windows Authentication Mode."
The database is now configured. Continue on to the Running Cascade Server section.