This weekend, I was trying to install Oracles UCM on Windows Server 2008 linking into MSSQL08 database running IIS7. Without much success, but its still early days and I have a week left of holiday to try and suss it out! Readon if your interested to see what I tried to do..

The first hurdle was getting the installation launcher.exe to run on Server 08 as the launcher does not recognise the operating system; this was soon fixed with  Jason Stortz of coreContentOnly suggestion to set it’s “compatibility” mode to 2003 Server.

Hurdle 2… At the moment the JTDS JDBC driver does not support MSSQL08 I did try it just encase..
So I headed to Microsofts downloads site and downloaded their JDBC driver 2.0 which does support MSSQL08 after many attempts to let the launcher connect with the driver with different configurations I gave up and decided to manually configure and install the database, I`m happy to say the SQL2005 and SQL2008 scripts (<ucm>/database/mssql/(yes I have no idea why they didn`t name this folder mssql2005??)) were compatible and allowed me to install all the tables. The next step was to try and configure the jdbc connection string and get the UCM talking to the database. So opened <ucm>/bin/intradoc.cfg and added JAVA_CLASSPATH_defaultjdbc=$SHAREDDIR/classes/msjdbc.jar - this needs to be added if you manually setup your DB connection and point to your jdbc connector. The last thing to do was to open the UCMs system properties app go into Database tab and add the jdbc connection string and driver name and finally open up the weblayout editor app and regenerate the portal.htm file.

Thats as far as I have got unfortunatly I`m still not having much luck with the JDBC driver.. But am investigating further… sigh..