Setting Up the Database (SQL Server)
Note: SQL Server 2012 support was added in Cascade Server 7.6.
Download the Cascade Server database.
Unzip the database and place the
cascade_log.ldf files in your SQL Server data folder
(e.g. C:\Program Files\Microsoft SQL Server\MSSQL\DATA)
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, select
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.
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
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:
ALTER DATABASE [databaseName] SET READ_COMMITTED_SNAPSHOT ON
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.