I have successfully installed my JIRA and SQL server 2014 on server. It started with embedded databased and worked well.
I want to change the DB to into SQL sever. Hence I changed the dbconf file as mentioned in the Atlassian documentation. But unable to connect and getting error. Please help.
My connection details are below.
But still I am unable to connect and getting error message like ....
I would follow the instructions in Switching Databases:
What value are you using for the URL tag? You don't need to disclose the exact value, I'm just interested to learn if you are using a hostname, IP address, or the value 'localhost'. From what I can see of your dbconfig.xml that looks fine, but it could be that SQL isn't listening on that port/address you are using to try to connect to.
If this is a hostname, then it is possible that the server can't resolve it's own hostname. That tends to happen when the server is configured to use a DNS server that doesn't know how to resolve that hostname to the expected IP address.
If JIRA and SQL are on the same machine, then I would recommend trying to use the localhost address. This is the equivalent of the 127.0.0.1 or the ::1 address that you might see in some systems.
It might be you have to configure SQL to listen to port 1433 on a specific interface of that system. Details on how to do this are in https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port I believe the default is listening on localhost for 1433, but you might have to make sure the SQL server is listening the port/address that you are actually trying to connect to.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot