nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Alfresco 7.2 MSSQL

Keiner

Hello,

I'm using Alfresco 7.2 version with docker and it's configured to use postgres database. I want to get connected to SQL Server. The idea is to use a docker-compose so I want to know if I just need to update the JAVA_OPTS (driver, url, user and password). I changed those parameters but I can't still get connected.

The way I found was changing the alfresco-global.properties file. Is this the only way or I can use the JAVA_OPTS option? In other word, what's the best approach to connect to SQL Server instance with alfresco 7.2 version?

Find more posts tagged with

Alfresco Content Services

Comments

angelborroy

Are you using Community or Enterprise edition?

If you are using Enterprise (Community version only supports PostgreSQL and MySQL/MariaDB) this may help you:

https://github.com/aborroy/search-2568

Keiner

I'm using Enterprice. I tried the connection by changing the JAVA_OPTS but it didn't work; it work when I move that to alfresco-global.properties. Wondering what's the correct way to configure MSSQL in docker-compose so I don't have to use alfresco-global.properties

Keiner

I forgot to mention. I don't want to use the mssql container but an external database instead