SQL Server password lost

[Daniel Lupu]

The SQL Sqerver holding the Confluence database was migrated and the user password lost. When I try to reinstall Confluence after changing the password (even on other machine) the System error page is displayed.

[Daniel Lupu · Accepted solution]

Hello all,

I solved my problem in a more brutal way. I recovered from a backup, rewrite the database, everything is ok, finally!

[C_ Faysal]

hi.

the password can be found in confluence_home_dir

check the onfluence.cfg.xml

<property name="hibernate.connection.password">your_password_is_here</property>

if you still have no success please send some detailed log lines

[Daniel Lupu]

hi,

Thanks for the unswer!

I found the password, the problem is that the schema is not right (MS SQL Server):

Caused by: org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is java.sql.SQLException: The SELECT permission was denied on the object 'BANDANA', database 'confluence', schema 'dbo'.

Caused by: java.sql.SQLException: The SELECT permission was denied on the object 'CLUSTERSAFETY', database 'confluence', schema 'dbo'.

[Daniel Lupu]

Hello all,

I solved my problem in a more brutal way. I recovered from a backup, rewrite the database, everything is ok, finally!