This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 69%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHW%3C/text%3E%3C/svg%3E)
Hi,
I can connect and process works in my code in localhost.
Sql server at another server.
When i pushed the code and test it on the test server, for example for an api in swagger page returns error which i mentioned at title.
I have created a rule on firewall but nothing changed.
Also my test server runs on openshift.
What is the problem?
(– Reasons. SQL Server does not have the authority to permit remote connection. This is because of a failure in connecting with the server case we are using. This error 40 in SQL server may also pop up due to badly configured firewall settings)
i can ping both servers. There are no any problem. But connection between test server and sql server which runs on openshift is a problem
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @Hello World ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
One thing to check is if SQL Server is configured to listen to remote connections. Check the SQL Server errorlog. It should list the IP addresses it is listening to.
Hi @Hello World ,
In case something is missing, you can check it against this article.
Resolve Error 40: Could Not Open a Connection to SQL Server
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.