topic Re: First Time Installation:Alfresco Fails to Deploy. SQL issue? in Alfresco Archive

First Time Installation:Alfresco Fails to Deploy. SQL issue?

johnboy1973 — Sun, 24 Feb 2008 11:34:10 GMT

11:01:09,687 ERROR [org.alfresco.repo.content.transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransformer not available: Failed to perform ImageMagick transformation: Execution result: os: Windows 2003 command: imconvert "C:\DOCUME~1\ADMINI~1.000\LOCALS~1\Te

Re: First Time Installation:Alfresco Fails to Deploy. SQL issue?

jitse — Mon, 25 Feb 2008 10:09:33 GMT

:shock:
Did you see ther errorlog you posted?

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'

AND

Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

It seems you configured alfresco to make use of mssql, but forgot to provide the jdbc-libraries needed to connect to it.
(you can place the libs in your /alfresco/tomcat/common/lib (or something corresponding)).

Check microsoft or google for your jdbc drivers. Or try MySQL as a database instead.

Re: First Time Installation:Alfresco Fails to Deploy. SQL issue?

johnboy1973 — Mon, 25 Feb 2008 21:32:19 GMT

Thanks for info. I saw the 'com.microsoft.sqlserver.jdbc.SQLServerDriver' error. but new to Alfresco and tomcat, so dont know what it means.

The jdbc files are in the lib folder. Still doesnt go, hence wondered what else could be wrong.

Cheers