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.