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

[ejholmgren]

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.

[pranjesh]

I am in a similar situation…except that the database is Oracle…

[shoshin]

This seems to alfresco user doesn't have adequate rights.
If you change it to database root password it is working properly.

Cheers!
Shoshin

[shoshin]

Please do also refer this following post.If your error falls under this category.
http://forums.alfresco.com/en/viewtopic.php?t=5369

Cheers!
Shoshin

[norgan]

Hi there,
I solved the problem by deleting the data folder and database and letting Alfresco redo the basic setup.

Regards, Norgan

[shoshin]

If the problem associates with Mysql can't read/write error you can try deleting the content from temp folder and do a restart.Usually it would be windows/temp directory. you can chk the mysql variables and figure out temp folder of yours.

Cheers!
Shoshin