Install

• Installing Cascade Server
• MySQL Configuration
• Oracle 9i Configuration
• Oracle 10g Configuration
• Running Cascade Server
• SQL Server 2000 Configuration
• Setting Up LDAP or Active Directory »
• Install

NEWS & TIPS

• Site Access Keys
• Top: Alt+t
  Previous: Alt+,
  Next: Alt+.
  Up: Alt+;
  (Note: use Ctrl on the Mac)

SQL Server 2000 Configuration

You will need to download and unzip the default MS SQL database:
http://www.hannonhill.com/downloads/cascade/mssql.zip

1. Expand a server group, and then expand a server.
2. Right-click Databases, and select All Tasks/Attach Database.
3. Enter the name of the MDF (master data file) of the database to attach. If you are not sure where the file is located, click browse (...) to search. There can only be up to 16 file names specified. For more information, see sp_attach_db.
4. To ensure that the specified MDF file is correct, click Verify. The Original File Name(s) column lists all the files in the database (data files and log files). The Current File(s) Location column lists the file names and paths. If Microsoft® SQL Server™ cannot find the files in the specified locations, the attach operation fails. The Current File(s) Location column can be edited, and the current location of the file must be in this column for the attach operation to work. For example, if you have changed the default location of the file before you detached it, you must specify the current location for the attach operation to be successful.
5. In the Attach as box, enter the name of the database. The database name must not match any existing database names.
6. Specify the database owner.
7. Click OK. A database node for the newly attached database is created in the Database folder.

1. Be Careful Please make sure that you have SQL Server 2000 Service Pack 4 installed: http://www.microsoft.com/sql/downloads/2000/sp4.asp

Wiki | Edit