MS-SQL 2019 GCP DB + More than one Alfresco schema was found when querying the database metadata.

Ghanshyam_R — Fri, 10 Oct 2025 08:39:52 GMT

Team,

I am using GCP MS-SQL studio, we are setting up new DEV environment for alfresco 7.3

I have user: alfresco_dev

While starting alfresco I am getting below error :

=========================================

JDBC Driver for SQL Server;applicationIntent=readwrite;, Microsoft JDBC Driver 9.4 for SQL Server 2025-10-10 08:15:15,439 INFO [domain.schema.SchemaBootstrap] [main] Schema managed by database dialect org.alfresco.repo.domain.dialect.SQLServerDialect. 2025-10-10 08:15:15,521 ERROR [domain.schema.SchemaBootstrap] [main] Schema auto-update failed org.alfresco.error.AlfrescoRuntimeException: 09100000 More than one Alfresco schema was found when querying the database metadata. Limit the database user's permissions or set the 'hibernate.default_schema' property in 'custom-hibernate-dialect.properties'. at

I tried applying below query to my MS_SQL studio:

ALTER USER alfresco_dev WITH DEFAULT_SCHEMA = dbo;

Still it is not reflecting, Is there anything I am missing here? Tried removing most permission from user and then giving only below :

----------------------

-- Reconnect to correct database
USE alfresco;

-- Make sure default schema is dbo
ALTER USER alfresco_dev WITH DEFAULT_SCHEMA = dbo;

-- Give connect permission to database
GRANT CONNECT TO alfresco_dev;

-- Allow Alfresco to create/read/write tables & indexes
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES, EXECUTE ON SCHEMA::dbo TO alfresco_dev;

-- Allow DDL (so Alfresco can auto-create or alter its tables)
GRANT CREATE TABLE, CREATE VIEW, CREATE PROCEDURE, CREATE FUNCTION TO alfresco_dev;

-- Optional: Let Alfresco modify schema (needed during first run)
GRANT ALTER, CONTROL, ALTER ON SCHEMA::dbo TO alfresco_dev;

still issue is same? Any idea how do I fix this?

Re: MS-SQL 2019 GCP DB + More than one Alfresco schema was found when querying the database metadat

roberto_gamiz — Mon, 20 Oct 2025 18:52:45 GMT

Hello,

Could you please sharing the DB config in global.properties file and your jdbc connector details. Sometimes this kind of problems are caused for compatibility issues with connectors.

Best Regards

topic MS-SQL 2019 GCP DB + More than one Alfresco schema was found when querying the database metadata. in Alfresco Forum

MS-SQL 2019 GCP DB + More than one Alfresco schema was found when querying the database metadata.

Re: MS-SQL 2019 GCP DB + More than one Alfresco schema was found when querying the database metadat