Como conectar alfresco community 5.2 con sql server2014?'

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Active Member

Como conectar alfresco community 5.2 con sql server2014?'

hola, 

Soy nueva en alfresco y me piden que conecte alfresco con sql server 2014 ya cambie la configuracion en el archivo 

alfresco-global.properties y no me funciona agradeceria su ayuda.


###############################
## Common Alfresco Properties #
###############################

dir.root=C:/alfresco-community/alf_data

alfresco.context=alfresco
alfresco.host=127.0.0.1
alfresco.port=8090
alfresco.protocol=http

share.context=share
share.host=127.0.0.1
share.port=8090
share.protocol=http

### database connection properties ###
db.driver=net.sourceforge.jtds.jdbc.Driver
db.username=sa
db.password=Admin123
db.name=alfresco
db.url=jdbc:sqlserver://COA-DESA8-IT\SQLEXPRESS:1433;databaseName=alfresco;instanceName=SQLEXPRESS;integratedSecurity=true
# Note: your database must also be able to accept at least this many connections. Please see your database documentation for instructions on how to configure this.
db.pool.max=275
Hibernate.dialect = org.alfresco.repo.domain.hibernate.dialect.AlfrescoSQLServerDialect
db.pool.validate.query=SELECT 1
db.txn.isolation=4096

# The server mode. Set value here
# UNKNOWN | TEST | BACKUP | PRODUCTION
system.serverMode=TEST

### FTP Server Configuration ###
ftp.port=21

### RMI registry port for JMX ###
alfresco.rmi.services.port=50500

### External executable locations ###
ooo.exe=C:/ALFRES~1/LIBREO~1/App/libreoffice/program/soffice.exe
ooo.enabled=true
ooo.port=8100
img.root=C:\\alfresco-community\\imagemagick
img.coders=${img.root}\\modules\\coders
img.config=${img.root}
img.exe=${img.root}\\convert.exe
alfresco-pdf-renderer.root=C:\\alfresco-community\\alfresco-pdf-renderer
alfresco-pdf-renderer.exe=${alfresco-pdf-renderer.root}\\alfresco-pdf-renderer.exe

jodconverter.enabled=false
jodconverter.officeHome=C:/ALFRES~1/LIBREO~1/App/libreoffice
jodconverter.portNumbers=8100

### Initial admin password ###
alfresco_user_store.adminpassword=209c6174da490caeb422f3fa5a7ae634

### E-mail site invitation setting ###
notification.email.siteinvite=false

### License location ###
dir.license.external=C:/ALFRES~1

### Solr indexing ###
index.subsystem.name=solr4
dir.keystore=${dir.root}/keystore
solr.host=localhost
solr.port.ssl=8081

### Allow extended ResultSet processing
security.anyDenyDenies=false

### Smart Folders Config Properties ###
smart.folders.enabled=false

### Remote JMX (Default: disabled) ###
alfresco.jmx.connector.enabled=false

1 Reply
Highlighted
Alfresco Employee

Re: Como conectar alfresco community 5.2 con sql server2014?'

Alfresco Community no funciona con Sql Server, únicamente con PostgreSQL, MySql y Mariadb.


Alfresco Enterprise funciona con MySQL, Oracle...

Software Engineer in Alfresco Search Team.