Microsoft SQL Server 2005-2019 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 SQLJDBC4.JAR file into the cdaily-5.0.0/WEB-INF/lib directory. If you're using JDK 1.5, copy SQLJDBC.jar not SQLJDBC4.jar
3. Start Microsoft SQL Server Management Studio.
4. Verify the server properties allow mixed mode authentication. If it's not set for mixed mode (Windows and SQL Server Authentication), change it to this mode.
5. Expand the desired server, and right click on the databases folder icon and select "New Database...".
6. 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.
7. 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".
8. 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.
9. From the menu, choose File | Open | File. Select the cdaily-5.0.0\WEB-INF\sql\MSSQL\calschema.sql file. If the authentication window appears, select SQL Server authentication and enter the user name and password you created in step 6.
10. 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.
11. 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;
      ApplicationName\=connectDaily 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 connectDaily and SQL Server installed on the same machine, you may run into a startup dependency. connectDaily may attempt to start before SQL Server. If this happens, the connectDaily 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.