圆4 If you want to use a dedicated administrator connection, restart SQL. i searched many sites for the problem but i couldn't find one correct solution. Since it sounds like the SQL server you want to use is not on the localhost, you will need to make sure that the SQL server has opened up the necessary ports so that your Jira server can reach it. not open a connection to SQL Server) (Microsoft SQL Server, Error: 2) The. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (Microsoft SQL Server, Error: 64) i didn't have this problem before 30 days ago(the connection sometimes disconnected but later connected). It is also possible that you will need to walk through this MS document on Configure the Windows Firewall to Allow SQL Server Access You will need to make sure that this server is using an interface and a port number that can be access from the Server running Jira. It provides detailed steps you can take on the SQL server side (you will need admin rights there) in order to see exactly how the SQL server is configured in regards to address and ports it's listening on. But take a look at this KB from Blackbaud: How to find the port being used by SQL Server I'm afraid your screenshots have obscured a bit more information that I wanted to see to be more helpful here.
It could be that there is a firewall in place, or that there are different settings within MS SQL in regards to which ports/addresses you can access that SQL server on. Your error messages just indicate that the Jira application can't connect to this database server.
