03-10-2020 01:29 PM
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
03-12-2020 01:58 PM
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,
03-12-2020 01:58 PM
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,
Explore our Alfresco products with the links below. Use labels to filter content by product module.