Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,560
Community Members
 
Community Events
165
Community Groups

During install, dB connection fails

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.

2 answers

0 votes

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.

0 votes

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

To allow log in.

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

Regards,
James.

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

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

My replies seem to be vanishing.

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 Community Leader Mar 31, 2022

Removed post from spam quarantine 

Like Ed Ahlsen-Girard likes this

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

208 views 1 4
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you