Help needed on BitBucket Server external database configuration

[xown solutions]

I was trying to install bitbucket server using external database but keep getting this recurring error.

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:217)
	com.atlassian.stash.internal.db.DefaultDatabaseManager.prepareDatabase(DefaultDatabaseManager.java:183)
	com.atlassian.stash.internal.maintenance.SpringMaintenanceTaskFactory.setupTask(SpringMaintenanceTaskFactory.java:151)
	...
Could not get JDBC Connection; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host WIN-JF075KC3N9L, port 1433 has failed. Error: "WIN-JF075KC3N9L. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
	org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
	com.atlassian.stash.internal.db.DefaultDatabaseValidator.validate(DefaultDatabaseValidator.java:44)
	com.atlassian.stash.internal.db.DefaultDatabaseManager.validateConfiguration(DefaultDatabaseManager.java:214)
	...
The TCP/IP connection to the host WIN-JF075KC3N9L, port 1433 has failed. Error: "WIN-JF075KC3N9L. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
	com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:191)
	com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:242)
	com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2369)
	...


Any suggestins on how I could resolve this. I"ve followed the installation instructions. Still can't figure out what is wrong.

[Stephen Sifers]

Hello and welcome to the Community!

From your error I see you are using Microsoft SQL server. You do have to configure your MS SQL instance to allow for externally connectivity after install. Along with enabling your SQL instance to allow communication over a port (commonly 1433). To find more about enabling remote connections to your SQL instance, please see Troubleshoot Connecting to the SQL Server Database Engine.

Along with this, ensure your Windows Firewall is not blocking any connections over the port which SQL is going to be connecting out of (commonly port 1433). To find out more about Windows Firewall configuration for SQL remote connections, please see: Configure a Windows Firewall for Database Engine Access.

Please let us know if you’re still having issues after enabling and allow remote connectivity to your database instance.

Regards,
Stephen Sifers