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; } } }

During install, dB connection fails

Ed Ahlsen-Girard

Test connection fails with:

SQLState - S0001
Error Code - 18456
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'FL\svc.confluence'. ClientConnectionId:5ea80abf-c37e-4aad-aed5-f668e612b956

There are no firewalls between the Confluence server and the SQL server. The server name, instance name, and database name are correct.

Accepted answers

All comments

James Richards

Hi @Ed Ahlsen-Girard

If you're sure the username/password are correct, then are you using Windows Authentication for the log in or or SQL Server Authentication?

If you are, you will need to follow these steps

https://confluence.atlassian.com/confkb/how-to-use-windows-integrated-authentication-for-microsoft-sql-server-in-confluence-6-5-or-newer-961785880.html

To allow log in.

Otherwise, is what is the full error in atlassian-confluence.log file?

Regards,
James.

Ed Ahlsen-Girard

Log below:

2022-03-31 15:02:56,749 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 7.17.0 [build 8803 based on commit hash 632f9efe86121f95476fcb3ba6290c01af548e3b] - synchrony version 4.0.0-master-bfb398fb
2022-03-31 15:03:02,577 INFO [Catalina-utility-1] [atlassian.plugin.manager.DefaultPluginManager] lambda$earlyStartup$5 Plugin system earlyStartup begun
2022-03-31 15:03:05,786 WARN [FelixStartLevel] [extender.internal.support.ExtenderConfiguration] addDefaultDependencyFactories Gemini Blueprint extensions bundle not present, annotation processing disabled.
2022-03-31 15:03:07,615 INFO [Catalina-utility-1] [atlassian.plugin.manager.DefaultPluginManager] logTime Plugin system earlyStartup ended
2022-03-31 15:03:07,615 INFO [Catalina-utility-1] [atlassian.plugin.manager.DefaultPluginManager] lambda$lateStartup$6 Plugin system lateStartup begun
2022-03-31 15:03:10,415 INFO [Catalina-utility-1] [atlassian.plugin.manager.DefaultPluginManager] logTime Plugin system lateStartup ended
2022-03-31 15:03:10,946 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] init Confluence is ready to serve
2022-03-31 15:03:13,899 WARN [http-nio-8090-exec-1] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 004930459515cffb | userName: anonymous | action: setupstandarddb-testconnection
2022-03-31 15:03:25,388 WARN [http-nio-8090-exec-2] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 00bb5b7eff3fc928 | userName: anonymous | action: setupstandarddb-testconnection
2022-03-31 15:03:30,467 WARN [http-nio-8090-exec-3] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 00fa5d3ae9a270ad | userName: anonymous | action: setupstandarddb-testconnection
2022-03-31 15:03:31,529 WARN [http-nio-8090-exec-4] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 00d7a1b404f346d8 | userName: anonymous | action: setupstandarddb-testconnection
2022-03-31 15:03:32,225 WARN [http-nio-8090-exec-5] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 004c38ad7bb07cd5 | userName: anonymous | action: setupstandarddb-testconnection
2022-03-31 15:03:32,828 WARN [http-nio-8090-exec-6] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 0099934be4cbeda9 | userName: anonymous | action: setupstandarddb-testconnection
2022-03-31 15:03:33,421 WARN [http-nio-8090-exec-7] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 0062da62627e5e73 | userName: anonymous | action: setupstandarddb-testconnection
2022-03-31 15:07:04,369 WARN [http-nio-8090-exec-9] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 005174c92ac33cc5 | userName: anonymous | action: setupstandarddb-testconnection
2022-03-31 15:07:08,243 WARN [http-nio-8090-exec-10] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 00e95c4cc7cc49b2 | userName: anonymous | action: setupstandarddb-testconnection
2022-03-31 15:07:09,172 WARN [http-nio-8090-exec-1] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 0011f0da6c828db6 | userName: anonymous | action: setupstandarddb-testconnection
2022-03-31 15:07:09,891 WARN [http-nio-8090-exec-2] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 00ab0e158d91dcbb | userName: anonymous | action: setupstandarddb-testconnection

Ed Ahlsen-Girard

2022-03-31 15:02:56,749 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 7.17.0 [build 8803 based on commit hash 632f9efe86121f95476fcb3ba6290c01af548e3b] - synchrony version 4.0.0-master-bfb398fb
2022-03-31 15:03:02,577 INFO [Catalina-utility-1] [atlassian.plugin.manager.DefaultPluginManager] lambda$earlyStartup$5 Plugin system earlyStartup begun
2022-03-31 15:03:05,786 WARN [FelixStartLevel] [extender.internal.support.ExtenderConfiguration] addDefaultDependencyFactories Gemini Blueprint extensions bundle not present, annotation processing disabled.
2022-03-31 15:03:07,615 INFO [Catalina-utility-1] [atlassian.plugin.manager.DefaultPluginManager] logTime Plugin system earlyStartup ended
2022-03-31 15:03:07,615 INFO [Catalina-utility-1] [atlassian.plugin.manager.DefaultPluginManager] lambda$lateStartup$6 Plugin system lateStartup begun
2022-03-31 15:03:10,415 INFO [Catalina-utility-1] [atlassian.plugin.manager.DefaultPluginManager] logTime Plugin system lateStartup ended
2022-03-31 15:03:10,946 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] init Confluence is ready to serve
2022-03-31 15:03:13,899 WARN [http-nio-8090-exec-1] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 004930459515cffb | userName: anonymous | action: setupstandarddb-testconnection
2022-03-31 15:03:25,388 WARN [http-nio-8090-exec-2] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 00bb5b7eff3fc928 | userName: anonymous | action: setupstandarddb-testconnection
2022-03-31 15:03:30,467 WARN [http-nio-8090-exec-3] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 00fa5d3ae9a270ad | userName: anonymous | action: setupstandarddb-testconnection
2022-03-31 15:03:31,529 WARN [http-nio-8090-exec-4] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 00d7a1b404f346d8 | userName: anonymous | action: setupstandarddb-testconnection
2022-03-31 15:03:32,225 WARN [http-nio-8090-exec-5] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 004c38ad7bb07cd5 | userName: anonymous | action: setupstandarddb-testconnection
2022-03-31 15:03:32,828 WARN [http-nio-8090-exec-6] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 0099934be4cbeda9 | userName: anonymous | action: setupstandarddb-testconnection
2022-03-31 15:03:33,421 WARN [http-nio-8090-exec-7] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 0062da62627e5e73 | userName: anonymous | action: setupstandarddb-testconnection
2022-03-31 15:07:04,369 WARN [http-nio-8090-exec-9] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 005174c92ac33cc5 | userName: anonymous | action: setupstandarddb-testconnection
2022-03-31 15:07:08,243 WARN [http-nio-8090-exec-10] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 00e95c4cc7cc49b2 | userName: anonymous | action: setupstandarddb-testconnection
2022-03-31 15:07:09,172 WARN [http-nio-8090-exec-1] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 0011f0da6c828db6 | userName: anonymous | action: setupstandarddb-testconnection
2022-03-31 15:07:09,891 WARN [http-nio-8090-exec-2] [com.opensymphony.xwork.DefaultActionInvocation] executeResult No result defined for action com.atlassian.confluence.setup.actions.SetupStandardDatabaseTestConnectionAction and result input
-- referer: http://dvs-conf:8090/setup/setupdbtype-start.action?thisNodeClustered=true | url: /setup/setupstandarddb-testconnection.action | traceId: 00ab0e158d91dcbb | userName: anonymous | action: setupstandarddb-testconnection

Ed Ahlsen-Girard

My replies seem to be vanishing.

Forrest Forrest

The "thisNodeClustered=true" part of your URIs is suspicious.
Having never tried installing Confluence before, I too noticed the same thing after definitely not selecting any clustering option on install.

Manually changing the address to include "thisNodeClustered=false" allowed me to proceed. And at least for me, it errored later on in the install process complaining about connecting to jira (which again, I definitely didn't select in the install process). Re-attempting a few times (and poking around with the address in the browser) eventually got it working for me.

I don't get the impression that the Confluence installer is very well tested.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

database