AnsweredAssumed Answered

Fresh install on W2K3/MSSQL 2K - 'Schema auto-update failed'

Question asked by ejholmgren on Aug 22, 2008
Latest reply on Oct 20, 2008 by shoshin
I am getting the following error with a fresh Alfresco Community 2.9.0B install on W2K3 and MSSQL 2K …

11:21:29,687 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: A previous schema upgrade failed.  Revert to the original database before attempting the upgrade again.

The sqljdbc.jar file has been placed in C:\Alfresco\tomcat\common\lib and the following dialect/repo properties have been set:

custom-hibernate-dialect.properties:
    hibernate.dialect=org.alfresco.repo.domain.hibernate.dialect.AlfrescoSQLServerDialect

custom-repository.properties:
    dir.root=C:/Alfresco/alf_data
    dir.indexes=C:/Alfresco/alf_data/lucene-indexes
    db.username=alfresco
    db.password=alfresco
    db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
    db.url=jdbc:sqlserver://localhost;DatabaseName=alfresco

What am I missing here? I don't believe that it's a db access problem because all the tables are being created. This same configuration worked flawlessly on two linux machines that I setup earlier.

Outcomes