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.

[Forrest Gump]

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.

[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.

[Ed Ahlsen-Girard]

I'll try to condense:
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

[Jack Brickey]

Removed post from spam quarantine