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

Where is the username and password stored for SQL Server database access?

Bill Hembree

confluence.cfg.xml does not show username and password for SQL Server database login.

Accepted answers

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

In most cases, it has to contain the database connection details, for Confluence to work. The exceptions are:

The Confluence has been configured to use a local embedded database (h2, not suitable for a production server). You may find blank entries for username/password, or even missing lines in this case, depending on version.
You have chosen to use JNDI in Tomcat instead of JDBC. You will find the database connection details in <confluence installation directory>/conf/server.xml See https://confluence.atlassian.com/doc/configuring-a-datasource-connection-937166084.html

All comments

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

In most cases, it has to contain the database connection details, for Confluence to work. The exceptions are:

The Confluence has been configured to use a local embedded database (h2, not suitable for a production server). You may find blank entries for username/password, or even missing lines in this case, depending on version.
You have chosen to use JNDI in Tomcat instead of JDBC. You will find the database connection details in <confluence installation directory>/conf/server.xml See https://confluence.atlassian.com/doc/configuring-a-datasource-connection-937166084.html

Bill Hembree

Confluence is working with a JDBC connection. Policies require the password to be changed every 60 days. Where is the password stored? If I change the password on the SQL Server user, I need to update it somewhere else so that the application can still log in to the database. The confluence.cfg.xml file does not show the current username and password that is in use, so I do not know where to update the password so the application works after changing the password.

Nic Brough -Adaptavist-

If you are using a JDBC connection, then the username, password, and connection string are in <confluence home>/confluence.cfg.xml

If you haven't got them in there, then you are not using a JDBC connection.

Could you be looking in a sample or copy of the confluence.cfg.xml?

Bill Hembree

I went to the confluence home directory and the confluence.cfg.xml file has none of our data in it. I don't know where else it could be.

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