I'm Trying to configure Jira on Azure and also MSSQL Database on Azure, but I'm getting an error: I/O Error: DB server closed connection.

[Felipe Albacete]

I'm Trying to configure Jira on Azure and also MSSQL Database on Azure.

ERROR: I/O Error: DB server closed connection.

JIRA is installed on a Virtual Machine.

MSSQL is not a Virtual Machine.

Is There any special configuration on Database Or Virtual Machine to do ?

Thanks for your Help!!!

[Nic Brough -Adaptavist-]

Are you using MS-SQL on the default port, and/or over SSL?

[Felipe Albacete]

Hi Nic!! It's on default port 1433. I deploy a simple project to test connection to MSSQL and works fine but JIRA gives me this error (sad) Thanks!

[Nic Brough -Adaptavist-]

Ok, but are you using a secure connection?

[Felipe Albacete]

No, it's not a secure connection Thanks!

[Nic Brough -Adaptavist-]

Ok, that has ruled out the two documented things this might be Could you take a look at your logs, find the error and then report on the root causes of it?

[Nic Brough -Adaptavist-]

That page covers the two situations that I've already mentioned, and are not the problem.

[rrudnicki]

Hi Felipe, 

There's a KB about this error: https://confluence.atlassian.com/display/JIRAKB/Unable+to+Connect+to+MS+SQL+Server+Due+to+DB+server+closed+connection

I believe it's worth taking a look at it.

Regards, 

Renato Rudnicki