database configuration error for stash with windows authentication

Question

The configuration entered is not valid. A database connection could not be established. Please check your configuration and try again.

If you continue having issues, get in touch with our support team and we'll help get you up and running.

Hide details

The configuration entered is not valid. A database connection could not be established. Please check your configuration and try again.

com.atlassian.stash.internal.db.DefaultDatabaseManager.validateConfiguration(DefaultDatabaseManager.java:195)

com.atlassian.stash.internal.migration.DefaultMigrationService.validateConfiguration(DefaultMigrationService.java:85)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

...

Could not get JDBC Connection; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'xyz. ClientConnectionId:1312a998-47bb-49c2-93b1-3f6d894a99d9

org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)

com.atlassian.stash.internal.db.DefaultDatabaseValidator.validate(DefaultDatabaseValidator.java:35)

com.atlassian.stash.internal.db.DefaultDatabaseManager.validateConfiguration(DefaultDatabaseManager.java:192)

...

Login failed for user 'xyz'. ClientConnectionId:1312a998-47bb-49c2-93b1-3f6d894a99d9

com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)

com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)

com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)

...

cybage_bitbucket · Answer

thanks michael

Michael Heemskerk · Answer

General instructions on how to connect Stash to a SQL server database can be found here: https://confluence.atlassian.com/display/STASH/Connecting+Stash+to+SQL+Server

If this doesn't help, I'd suggest opening a support request on https://support.atlassian.comso our support engineers can have a look at your logs.

Nic Brough -Adaptavist- · Answer

Er, have you read the error you've posted here?  It specifically states that you have not given it user details that can connect to your database.

The solution is to ensure you've set up the database correctly, and give stash the right credentials.