Microsoft SQL Server 2000 Configuration

1. Visit http://www.microsoft.com/sql/technologies/jdbc/default.mspx 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 SQLJDBC.JAR file into the cdaily-3.4.2/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.4.2/WEB-INF/sql/SQL2K/calschema.sql file.
9. Execute the 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.

Microsoft SQL Server 2005/2008 Configuration

1. Visit http://www.microsoft.com/sql/technologies/jdbc/default.mspx and download the Microsoft JDBC drivers, and install them.
2. Copy the installed SQLJDBC.JAR file into the cdaily-3.4.2/WEB-INF/lib directory.
3. Start Microsoft SQL Server Management Studio.
4. Expand the desired server, and right click on the databases folder icon and select "New Database...".
5. Enter the name of the database and set the file sizes. 64MB for the database and 8MB for the transaction log should be sufficient for most users.
6. Expand the Security folder and right click on the Logins folder and select "New Login...". Set the default database for the new User ID to your new calendar database. Select "SQL Server Authentication" and enter a user name and password You must create the account with the Authentication setting set to SQL Server Authentication. Uncheck "Enforce Password Expiration" and "User must change password at next login".
7. In the left pane, click on User Mapping. Put a check in the box for your calendar database. In the "Database role membership for" box, check db_owner. Click on OK to complete adding the user.
8. From the menu, choose File | Open | File. Select the cdaily-3.4.2/WEB-INF/sql/SQL2K/calschema.sql file. If the authentication window appears, select SQL Server authentication and enter the user name and password you created in step 6.
9. Ensure the new calendar database is the currently selected database (selected in the database dropdown list) and execute the script by clicking on the toolbar Execute button.
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.