Windows Installation
The following provides complete instructions on installing Cascade Server on a Microsoft Windows 2000/XP/2003 computer. All necessary components are included in this installation. Should you have questions at any time please call us at (678) 904-6900.
We recommend Microsoft SQL Server, MySQL or Oracle as your database. As part of the installation you will need some database familiarity to setup and configure the software.
Note: If the MSDE installer prompts a reboot of your machine, please reboot the machine and then run cascade_full_nnn.exe again selecting yes to have MSDE installed. This is necessary to properly create the database and tables. MSDE does not work on all systems and MS SQL Server or MySQL is recommended.
Install Steps
- Run the full installer .exe program
- If you are not using the MSDE, create your database and configure it with ServerManager (optional)
- Start the Cascade Server batch script
- Install the Windows Service (optional)
- Point your browser to the server and you're ready to go
Start-up Cascade Server
To run Cascade Server first start by double clicking the "Cascade Server" shortcut on your desktop. This will cause a batch window to open up which can be ignored. Next, open your web browser and go to the url:
http://MACHINE_IP_ADDRESS:8080/admin/index
which will take you to the log in page. The default username and password to login:
username: admin
password: admin
That's it! You're ready to go. Please contact us at (800) 407-3540 if you have any questions.
To install the Windows Service, please run:
c:\Program Files\Cascade Server\cascade\bin\InstallService.bat
Optional: Microsoft SQL Server Config ^
You will need to download and unzip the default MS SQL database:
http://www.hannonhill.com/downloads/cascade/mssql.zip
Now unpack the zip file and attach the cascade.mdf file to your MS SQL Server. It is also very important to make sure you have SQL Server Authentication enabled. To do this in Enterprise Manager right click on the server and select "Properties". Now click on the "Security" tab. Make sure authentication is set to "SQL Server and Windows." Now click on the "General" tab and click the button labeled "Network Configuration..." Make sure TCP/IP is in the Enabled Protocols box.
Now run c:\CascadeServer\cascade\bin\ServerManager.exe (requires the .NET 1.1 runtime environment installed) and configure your SQL Server settings accordingly.
Please make sure that you have SQL Server 2000 Service Pack 4 installed:
http://www.microsoft.com/sql/downloads/2000/sp4.asp
Please restart Cascade Server and you should be ready to go.
Optional: MySQL Config ^
Download and install MySQL 5.0 from:
http://dev.mysql.com/downloads/mysql/
Please open your MySQL my.ini file and add the following under your [mysqld] section:
set-variable=max_allowed_packet=16M
set-variable=key_buffer=16M
Please restart your MySQL server for these changes to take (these allow files up to 16 megabytes in size).
You will need to download the default Cascade Server database:
http://www.hannonhill.com/downloads/cascade/mysql.zip
Please unzip the default database into your mysql/bin folder.
Now we need to create a new database and load the Cascade Server tables into the database. At the command prompt type:
mysqladmin -u root -p create cascade
If using MySQL 4.1, please enter the following commands:
mysql -u root -p
ALTER DATABASE `cascade` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
exit
mysql --default-character-set=utf8 -u root cascade < cascade.sql
If using MySQL 4.0, please enter the following commands:
mysql -u root -p cascade
source cascade.sql
The database and all necessary tables are now created.
Now run c:\CascadeServer\cascade\bin\ServerManager.exe (requires the .NET 1.1 runtime environment installed) and configure your MySQL settings accordingly.
Please restart Cascade Server and you should be ready to go.
Speed Optimizations
There are several items that can be done to improve performance of Cascade Server on Windows.
- Increase the amount of memory allocated to the program. The default is 512 MB. Increase this to the maximum amount allowed by your system. Look for the -Xmx value in either the run.bat or the wrapper.conf file located in the bin folder.
- Increase the connection pooling values for the database. Open your ***-ds.xml file for your respective database and increase the cache size.
- If you are running Cascade Server as a Windows Service, increase the service priority from NORMAL to HIGH. This can be done by adding the following value in your wrapper.conf and uninstalling and reinstalling the Windows Service:
wrapper.ntservice.process_priority=HIGH