Connecting Alfresco Community Edition with SQL Server

marcelo2m97 — Tue, 10 Mar 2020 17:29:16 GMT

I was following the Alfresco Content Services documentation in which indicates how to link Alfresco CM with a SQL Server database (https://docs.alfresco.com/6.0/tasks/sqlserver-config.html).

After saving my alfresco-global.properties and restarting my services I went to my Alfresco Site and I couldn't start a session with any user. After that I went to the "/" directory and it says this: "Cannot find Alfresco Repository on this server. (Does this application have access to alfresco-global.properties? Does this application have cross-context permissions?)"

What can I do to fix it?

I leave here my alfresco-global.properties

dir.root=C:/Alfresco/alf_data

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

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

db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
db.username=alfresco
db.password=alfresco
db.name=alfresco
db.host=localhost
db.port=1433
db.pool.max=275
db.url=jdbc:sqlserver://${db.host}:${db.port};databaseName=${db.name};lockTime=1000;
db.txn.isolation=4096
db.pool.validate.query=SELECT 1

system.serverMode=UNKNOWN

ftp.port=21

alfresco.rmi.services.port=50500

ooo.exe=C:/ALFRES~2/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~2/LIBREO~1/App/libreoffice
jodconverter.portNumbers=8100

alfresco_user_store.adminpassword=329153f560eb329c0e1deea55e88a1e9

notification.email.siteinvite=false

dir.license.external=C:/ALFRES~2

index.subsystem.name=solr4
dir.keystore=${dir.root}/keystore
solr.host=localhost
solr.port.ssl=8443

security.anyDenyDenies=false

smart.folders.enabled=false

alfresco.jmx.connector.enabled=false

Re: Connecting Alfresco Community Edition with SQL Server

EddieMay — Thu, 12 Mar 2020 17:58:29 GMT

Hi @marcelo2m97,

Alfresco Community EDITION provides ONLY support for PostgreSQL, MySQL and MariaDB. The Enterprise ACS does support MS SQL but not the community edition.

HTH,

topic Re: Connecting Alfresco Community Edition with SQL Server in Alfresco Forum

Connecting Alfresco Community Edition with SQL Server

Re: Connecting Alfresco Community Edition with SQL Server