Microsoft SQL Server 2000 Configuration

1. Visit http://www.microsoft.com/sql/downloads/default.asp and download the Microsoft JDBC drivers (the instructions here are for the SQL Server 2005 JDBC drivers, which work with SQL Server 2000), and install them.
2. Copy the installed JAR file into the cdaily-3.3.6/WEB-INF/lib directory. If you used the downloader installation, copy the files to the cdaily-3.3.6\WEB-INF\lib directory.
3. Start SQL Enterprise Manager
4. Right click on a server and select NEW | DATABASE.
5. Enter the name of the database and set the file sizes. 16MB for the database and 2MB for the transaction log should be sufficient for most users.
6. In SQL Enterprise Manager, expand the folder labeled Security. Right click on the Logins icon and choose New Login. Create the User ID to use for the database connection. Set the default database for the new User ID to your new calendar database. It is important to note that the MS JDBC driver will not work with Windows security. You must create the account with the Authentication setting set to SQL Server Authentication.
7. On the Database Access tab, put a check mark for the new database. In the "Database roles for <dbname>" box, check the option for db_owner. Save changes to the User account.
8. Open SQL Query Analyzer and connect to the server using the new User ID and password. Select the new database. Open the cdaily-3.3.6/WEB-INF/sql/SQL2K/calschema.sql file.
9. Execute the calschema.sql script by clicking on the green triangle icon.
10. Edit the configuration.properties file, putting in the configuration entries for your database. The entry should look something like (but each entry on one complete line):
    
    DBObjectClass=com.MHSoftware.db.support.SQLServerDB
JDBCDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBCConnectString=jdbc\:sqlserver\:
      //yourserver.yourcompany.com;
      DatabaseName\=Calendar;
      ProgramName\=Connect Daily Web Calendar

JDBCPassword=calendar
JDBCUserID=calendar

Refer to the JDBC Driver help topic entitled Connecting to SQL Server with the JDBC Driver for additional information on JDBC configuration options.

Gotcha Warning!

If you have Connect Daily and SQL Server installed on the same machine, you may run into a startup dependency. Connect Daily may attempt to start before SQL Server. If this happens, the Connect Daily application will not run correctly and you'll get errors. To correct this, create a registry value of type Multi-String Value (REG_MULTI_SZ) named DependOnService in the key HKEY_LOCAL_MACHINE\SYSTEM\ CurrentControlSet\Services\ConnectDaily. For the value of DependOnService enter MSSQLSERVER.