Connecting Alfresco Community Edition with SQL Server

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Member II

Connecting Alfresco Community Edition with SQL Server

Jump to solution

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

 

1 Solution

Accepted Solutions
Highlighted
Community Manager
Community Manager

Re: Connecting Alfresco Community Edition with SQL Server

Jump 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,

Digital Community Manager, Alfresco Software.
Problem solved? Click Accept as Solution!

View solution in original post

1 Reply
Highlighted
Community Manager
Community Manager

Re: Connecting Alfresco Community Edition with SQL Server

Jump 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,

Digital Community Manager, Alfresco Software.
Problem solved? Click Accept as Solution!

View solution in original post