External database connection fails at setup

Question

Hi,

I am setting up BitBucket server for the first time. I am setting up the bitBucket application on one Windows server and creating the SQL server database on another Windows server.  the database has been created okay and the Bitbucket user login works in SSMS to connect to the database.  The two servers can see each other as I can ping each from the other.  I checked that TCP\IP is enabled in the SQL server engine install.

However, when i attempt to configure the database connection in BitBucket, enter the database details and click "Test" the message states,

"The configuration entered is not valid. A database connection could not be established. Please check your configuration and try again".  Full details are copied in below (IP address hidden on request of my manager).  How do I resolve this please?  Do I setup Firewall rules inbound or outbound on each server?

com.atlassian.stash.internal.db.DefaultDatabaseManager.validateConfiguration(DefaultDatabaseManager.java:217)
	com.atlassian.stash.internal.migration.DefaultDatabaseMigrationService.validateConfiguration(DefaultDatabaseMigrationService.java:85)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	...
Failed to obtain JDBC Connection; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host XXX.XX.XXX.XX, port 1433 has failed. Error: "Connection refused: connect. 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:82)
	com.atlassian.stash.internal.db.DefaultDatabaseValidator.validate(DefaultDatabaseValidator.java:43)
	com.atlassian.stash.internal.db.DefaultDatabaseManager.validateConfiguration(DefaultDatabaseManager.java:214)
	...
The TCP/IP connection to the host XXX.XX.XXX.XX, port 1433 has failed. Error: "Connection refused: connect. 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:226)
	com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:277)
	com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2379)
	...

Alan Farroll_665zg5 · Answer

@Moses Thomas Thanks Moses. Some interesting update now. Yes, the BitBucket application is on a different server to the database engine (restricted by SQL server license and space on the database server is forcing me to do it this way) I tried a UDL file and it connected from the BitBucket server to the database on the database server successfully. HOWEVER - I setup Telnet on the BitBucket server and typed the command C: elnet 1433 The output was "Connecting to ... could not open connection to the host on port 1433" I am double checking with infrastructure team if anything on network is blocking the connection Will update when I have information Cheers. Alan

Moses Thomas_08kyb0 · Answer

@Alan Farroll I then in the TCP\IP properties i) For IP4 changed the IP Address from 127.0.0.1 to 0.0.0.0 Don't do that! leave it at it is ( local host IP). I have questions for you. * The MS SQL sever is it on the same host as Bitbucket server ? * 1. If yes Open a command prompt Type in "telnet " and press enter. type “telnet 127.0.0.1 1433” If a blank screen appears then the port is open, and the test is successful other wise some is blocking connection to this port. Imagine what is happening A=Bitbucket B=Database , A sents a connection request to B, but B is open for a connect(TCP at 1433) * 2. If both servers are install on a different host, then ensure that both servers are able to communicate with each other, more also bind-Address will make more sense, which will be in the my.ini on the MSSQL server, this address should be 0.0.0.0 or static ip address of the MSSQL server. * What is host XXX.XX.XXX.XX, in the error ? is it the same as local host IP ?

Alan Farroll_665zg5 · Answer

@Moses Thomas

Thanks again for more feedback.  So, here is where we are at;I ensured the TCP\IP protocol is enabled
I have ensured in the TCP\IP properties,
      i) The IP4 is active
      ii) The port TCP Port is set to 1433
     (there doesn't appear to be a IP6)
I restarted the SQL server service, the SQL Server Agent and the SQL Server Browser
Restarted the BitBucket Service but still had same issue

I then in the TCP\IP properties
     i) For IP4 changed the IP Address from 127.0.0.1 to 0.0.0.0
Again, I restarted the SQL server service, the SQL Server Agent and the SQL Server Browser
Restarted the BitBucket Service but still had same issue

I went to the SQL Server Service, right clicked and selected properties and took note of the path which was C:\Program Files\Microsoft SQL Server\MSSQL13.SQLServerInstanceName\MSSQL\BINN
Looked in there and found 4 files of type .ini but none of these had a "bind-address" parameter

I also ensured the BitBucket machine had a BITBUCKET_HOME environment variable with a value of C:\Atlassian\Bitbucket\7.0.0 (this was created with the install as a service process)

I have looked at the C:\Atlassian folder and the CREATOR_OWNER has special permissions which in special permissions is Full Control (I am assuming this is enough because the altBitbucket user would set this folder up and be the CREATOR_OWNER

I ensure the altBitbucket user was a member of the Performance Monitoring Group on the server too.

Still cannot find what I am doing wrong!!!