· Trying to connect to mssql server 2008 database in Jira
o Created new database
o Created new login/user with db_owner permissions on new database
o Used config.bat for config
§ Entered ‘localhost’ (no quotes) for hostname
§ Database, username & password
§ Port 1433
§ Schema: blank
o When i test connection I get ‘Could not connect to the DB: Network error IOException: Connection refused: connect’
o I’ve checked that the default port on sql server is 1433 and that it’s a static port.
o Firewall: it is on (but i tried testing the connection w/the firewall down and still got this error message)
I’ve checked the schema and collation type are correct, tcp/ip is enabled and mssql jtds driver is present and working. I also confirmed that the authorization is sql server and windows auth.
Any suggestions as to what to try next?
Its an issue of the dynamic port.
Goto Windows-Start->Programs->Microsoft SQL Server 20xx->Configuration Tools->SQL-ServerConfiguration-Manager
After starting this Configuration Tool go to SQL-Server-Network-config.-> protocols for [instance name]
Open TCP/IP at right site
Choose IP-Adresses above.
Scroll down to IPAll
Insert in the field for TCP-Port your port 1433
Restart SQL-Server service.
u can check if your server is now listening on port 1433 with queries
sp_ReadErrorLog --(sql server 2012)
Xp_readerrorlog --(sql server 2008 and below)
in the result you should read something like
Server is listening on [ 'any' <ipv6> 1433].
Server is listening on [ 'any' <ipv4> 1433].
I ran into this or something similar when installing both JIRA and Confluence server solutions (on premise) to use SQL Server 2012. Our DB runs in a cluster which some other users may encounter as well. I found this article which solved my problem for both JIRA and Confluence setup:
Basically when using the setup wizard, type this in the DB name field: <DB_NAME_HERE>;instance=<DB_INSTANCE_NAME_HERE>
I don't know if this is the proper resolution, but this worked for me in my case
Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs