Is IP:Port/Database the only way to connect Confluence to a SQL DB, or is there a way to connect with a DNS entry Servername\InstanceName?

Chad Lane

rrudnicki

Hi Chad, 

 

Both IP Address and DNS hostname  work on database connection.

 

For a JDBC connector, you can use the following:

 

jdbc:jtds:sqlserver://<server>:<port>/<database>

 

If MS SQL is clustered, use this format:

 

jdbc:jtds:sqlserver://<server>:<port>/<database>;instance=<instance>

 

On this link you can find more details:

https://confluence.atlassian.com/display/DOC/Database+Setup+for+SQL+Server

 

Best regards, 

Renato Rudnicki