Setup your database - 'The port number ____ is not valid.'

[James Bloggs]

I'm trying to set up confluence with a MS SQL Server database - both in docker containers(Ubuntu images provided by Atlassian and MS).

Both containers are running, with my database created and the various environment variables set as directed.

In browser, at 'Setup your database' I get the following:

Problem connecting to your database

com.microsoft.sqlserver.jdbc.SQLServerException: The port number sqlserver://db:1433 is not valid.

This is refering to my entry in 'Hostname:' which is 'jdbc:sqlserver://db:1433;databaseName=confluence'. All other fields are filled in correctly as far as i can tell. Apologies for the lack of pictures.

Any help appreciated!

[Kishan Sharma]

Hi @James Bloggs Welcome to the Atlassian Community! Please check if you have configured MS SQL to allow connection to port 1433 for SQL to communicate. Refer comment on this article, which is relevant here too.

[James Bloggs]

@Kishan Sharmathanks for your help, the real issue was an incorrectly installed driver. Thank you for your time!

[Kishan Sharma]

you are welcome James, glad you got it working now!

[James Bloggs]

Me too :D

[Alan Stephenson]

Try to telnet to the server using port 1433. Like

telnet servername 1433

if you get a response then the port is listening. If you get a waiting message make sure port 1433 is listening or enabled on both sides (source and destination)

[James Bloggs]

Thanks to you as well Alan! Sorry about the time wasting.

[Alan Stephenson]

No worries. I am glad you got it working. These type of errors sometimes are hard to find. I suggested that one because from my experience with SFTP processes and port numbers. If the port isn't "listening" the connection won't happen.

[James Bloggs]

Ok, also of note was the Hostname at set up needed to be different to the format in the docs... for me '<hostname>:<port_number>' worked by fluke, instead of the longer format given in the docs.