SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
413 questions
Unable to Access SQL Server Database on Azure VM After Deploying API to Azure Container Apps
![](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(48, 61%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EII%3C/text%3E%3C/svg%3E)
Irene IRADUKUNDA
0
Reputation points Microsoft External Staff
Hello,
I have set up an Azure Virtual Machine (VM) where I have my development environment configured, including Visual Studio Code 22 and SQL Server. Recently, I deployed my API using Azure Container Apps. However, I am encountering issues when trying to access the SQL Server database from my deployed API. The connection attempts keep failing. The connection on my development environment is ok. Below is a screenshot of the error.
Steps taken to fix:
- Checked the instance name (Ok)
- Enabled Remote connection on SQL Server Management Studio
- Enabled TCP/IP on SQL Server Configuration Manager
- Added inbound & outbound rule to my Windows Defender Firewall to allow connection on port 1433.
- Both The SQL Server and SQL Server Browser are running.
SQL Server on Azure Virtual Machines
{count} votes
-
![](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(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani 2,485 Reputation points Microsoft External Staff Moderator2025-04-18T15:50:45.51+00:00 Hi Irene IRADUKUNDA,
Greetings!
We apologize for the inconvenience caused.
As we understand that, you are unable to connect from your deployed API to the SQL Server database on your Azure VM.
We would like to inform you that, the error message from your screenshot indicates a network-related or instance-specific error while establishing a connection to SQL Server. The server was not found or was not accessible, and the connection was forcibly closed by the remote host.
Here are some additional steps you can take to troubleshoot and resolve the issue:
- Network Security Group (NSG) Configuration: Ensure that the SQL port 1433 is enabled from your external IP address in the Azure VM network security group. This is crucial for allowing remote connections to your SQL Server.
- VPN Connection: Verify that you are connected to VPN if required for accessing the SQL Server. Sometimes, VPN configurations can impact connectivity.
- Azure Container Apps Configuration: When deploying the API to Azure Container Apps, ensure that the environment variables include the correct database connection string. Use managed identities and role-based access control to manage access between your database and host
- SQL Server Configuration: Double-check the SQL Server configuration to ensure that TCP/IP protocol is enabled and the SQL Server service is restarted.
- Firewall Rules: Make sure to open firewall rules in the path from the server, including Windows Firewall, Corporate Firewall, or Azure NSG. This ensures that the connection is not blocked at any point.
- Private IP Address: Try connecting to the SQL Server using its private IP address from within the VM to verify if the issue is related to external access.
- Azure SQL VM CLI: Utilize Azure SQL VM CLI for managing SQL Server configurations on Azure VM. This can help automate and simplify the process of configuring SQL Server settings.
Here are links to several parallel threads that may be helpful to you:
I hope this information helps. Please do let us know if you have any further queries.
If the comment is helpful, please click "Upvote it".
-
Vijayalaxmi Kattimani 2,485 Reputation points Microsoft External Staff Moderator
2025-04-21T09:34:50.21+00:00 Hi @Irene IRADUKUNDA,
We haven’t heard from you on the last response and wanted to follow up to check if your issue has been resolved.
If you have found a solution, we would appreciate it if you could share it with the community, as it may be helpful to others. Otherwise, please provide more details, and we will do our best to assist you further.
-
![](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(166.4, 95%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Saraswathi Devadula 2,740 Reputation points Microsoft External Staff Moderator2025-04-22T08:47:36.83+00:00 Hi Irene IRADUKUNDA,
We haven’t heard from you on the last response and wanted to follow up to check if your issue has been resolved.
If you have found a solution, we would appreciate it if you could share it with the community, as it may be helpful to others. Otherwise, please provide more details, and we will do our best to assist you further.
-
Vijayalaxmi Kattimani 2,485 Reputation points Microsoft External Staff Moderator
2025-04-23T13:51:54.2533333+00:00 Hi @Irene IRADUKUNDA,
We haven’t heard from you on the last response and wanted to follow up to check if your issue has been resolved.
If you have found a solution, we would appreciate it if you could share it with the community, as it may be helpful to others. Otherwise, please provide more details, and we will do our best to assist you further.
-
Irene IRADUKUNDA 0 Reputation points Microsoft External Staff
2025-05-14T14:44:00.4833333+00:00 Hello @Vijayalaxmi Kattimani , sorry I couldn't get back to you faster. I've decided to change my approach and went with Azure SQL. Thank you for your assistance.
Sign in to comment
Sign in to answer