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
Solved! Go to Solution.
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,
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,
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.