SQL Server 2000 with Alfresco, Help

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

manuel

Hi, first sorry my english.

I have done the this steps:

1) I create database Alfresco

2) To copy msbase.jar, mssqlserver.jar, msutil.jar (Microsoft SQL Server 2000 Driver) in TOMCAT\common\lib

3) I modified hibernate-cfg.properties:

hibernate.dialect=org.hibernate.dialect.SQLServerDialect
‍‍‍

And repository.properties:

db.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver 
db.name=Alfresco 
db.url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=${db.name} 
db.username=alfresco 
db.password=alfresco
‍‍‍‍‍‍‍

I have this error:

10:27:05,920 ERROR [org.hibernate.util.JDBCExceptionReporter] Cannot load JDBC driver class 'com.microsoft.jdbc.sqlserver.SQLServerDriver '
10:27:19,890 ERROR [org.hibernate.util.JDBCExceptionReporter] Cannot load JDBC driver class 'com.microsoft.jdbc.sqlserver.SQLServerDriver '
10:27:19,910 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] could not get database metadata
…….
‍‍‍‍‍‍

I do not understand this, because the class of the driver is this:

 package com.microsoft.jdbc.sqlserver; ‍

Helpme, thanks

csiege

you have to download the microsoft sql server jdbc driver and copy the jar file to the alfresco install…

Copy sqljdbc.jar to C:\apps\alfresco\tomcat\webapps\alfresco\WEB-INF\lib folder