Setting Up the Database (SQL Server)

Installing to SQL Server 2005/2008/2012

Note: SQL Server 2012 support was added in Cascade Server 7.6.

Step 1: Download Cascade Server database

Download the Cascade Server database.

Unzip the database and place the cascade.mdf and cascade_log.ldf files in your SQL Server data folder (e.g. C:\Program Files\Microsoft SQL Server\MSSQL\DATA)

Step 2: Attach the Cascade Server database to SQL Server

Open SQL Server Management Studio. In SQL Server Management Studio Object Explorer, connect to an instance of the Microsoft SQL Server Database Engine and then expand that instance.

Right-click Databases, and select Attach. The Attach Databases dialog box appears.

To specify the database to be attached, click Add. In the Locate Database Files dialog box, navigate to the SQL Server data folder into which you just dropped the database files, selectcascade.mdf, and click OK.

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. (Optional)

To change the owner of the database, select a different entry in the Owner column. (Optional)

Click OK to complete the database attachment.

Step 3: Enable SQL Server authentication

SQL Server authentication must be enabled. To enable this:

  • Right-click on the Server in the Object Explorer and select Properties
  • Select the Security section
  • Verify that authentication is set to SQL Server and Windows Authentication Mode

Step 4: Set the Database Isolation Level to snapshot

Setting the isolation level to 'snapshot' increases performance with Cascade Server.

Execute the following query while Cascade Server is not running and no other connections to the database are open:


where [databaseName] is the name of your Cascade Server database.

Your SQL Server database is now configured and ready to be used by Cascade Server.