Does it support sqlserver?

[jianlins]

Does it support sqlserver?

[reckart]

We have an integration test which checks that the app can boot up on MS SQL Server and perform a few basic operations.

However, there hasn't been much testing on MS SQL Server.

So the answer is: maybe ;)

[jianlins]

I use the following configuration for settings.properties

server.port=8087
database.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
database.url=jdbc:sqlserver://server_url;databaseName=ANNO;integratedSecurity=true;encrypt=false;CharacterSet=UTF-8
spring.jpa.properties.hibernate.default_schema=inception
spring.jpa.hibernate.ddl-auto=update

with mssql-jdbc-12.10.0.jre11.jar

It does load the default admin reset password page. However, after I set the password, it failed to login (I am sure the password is correct, tried multiple times). Tested on both 36.3 and 36.4

2025-06-03 00:36:58 INFO [SYSTEM] boot - You can now access INCEpTION at http://localhost:8087/
2025-06-03 00:37:49 INFO [SYSTEM] InitialAccountCreationPanel - Default admin account password and permissions have be reset.
2025-06-03 00:37:51 WARN [SYSTEM] ApplicationPageBase - anonymousUser: Default admin account password and permissions have be reset.
2025-06-03 00:38:01 WARN [SYSTEM] SpringAuthenticatedWebSession - User [admin] failed to login. Reason: Bad credentials
2025-06-03 00:38:03 ERROR [SYSTEM] ApplicationPageBase - anonymousUser: Login failed

Any idea where and how to fix?

[jianlins]

Yes, I did and I did see the tables are created. just failed in login after change admin's password. since that's the only different configure we have, I wonder if the connection is coded differently between creating tables vs. login (or update password).

[reckart]

The db connection and the user login are not related. Can you check if the credentials are actually created in the users table in the database?

[reckart]

btw, you should not use "spring.jpa.hibernate.ddl-auto=update" because INCEpTION uses Liquibase to set up the tables. So Hibernate must not also try setting up tables, otherwise you will have conflicts.

[jianlins]

yes. it created. without "spring.jpa.hibernate.ddl-auto=update", it won't be able to connect at all. I probably should take a look how to configure Liquibase to use windows authentication.

[reckart]

Liquibase should piggy-back on the JDBC connection set up by Spring. No extra configuration should be necessary.