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?
