Install Alfresco

Prepare database (in this case a SQL Server 2000 database)

• Create a database named alfresco
• Create a database user named alfresco and make it owner of the newly created alfresco database

Prepare Alfresco

• Download Alfresco: alfresco-community-tomcat-2.9.0B.zip
• Unzip content to D:\Alfresco
• Install JDBC driver
  • SQLServer 2005:
    Copy sqljdbc.jar to \tomcat\common\lib
    Copy sqljdbc_auth.dll to \system32
  • SQLServer 2000:
    Copy jtds-1.2.1.jar to to \tomcat\common\lib
• In alfresco\tomcat\shared\classes\alfresco\extension directory
• Edit custom-hibernate-dialect.properties to use SQLServer dialect:
  hibernate.dialect= org.alfresco.repo.domain
  .hibernate.dialect.AlfrescoSQLServerDialect
• Edit custom-repository.properties to use alfresco database
  SQLServer 2005:
  db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
  db.url=jdbc:sqlserver://localhost; DatabaseName=alfresco; IntegratedSecurity=true
  #db.url=jdbc:sqlserver://localhost; DatabaseName=alfresco; User Id=alfresco;Password=alfresco;

  SQLServer 2000:
  dir.root=D:/Alfresco/Data
  db.username=alfresco
  db.password=alfresco
  db.pool.initial=10
  db.pool.max=100
  db.driver=net.sourceforge.jtds.jdbc.Driver
  db.url=jdbc:jtds:sqlserver://localhost/alfresco

• Edit alfresco/tomcat/conf/server.xml and change port from 8080 to 80
• Edit service.bat to increase jvm memory: –JvmMs 512 –JvmMx 1024
• Install alfresco as a windows service: tomcat\bin\service install Alfresco