AnsweredAssumed Answered

Como conectar alfresco community 5.2 con sql server2014?'

Question asked by paty on Nov 21, 2018
Latest reply on Nov 22, 2018 by angelborroy

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

Outcomes