Azure SQL Database
An Azure relational database service.
5,622 questions
Visual Studio 2019 connecting to Azure SQL Database error
![](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(38.4, 46%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKY%3C/text%3E%3C/svg%3E)
Kutay Yalçıner
1
Reputation point
I have an API that works fine on my local computer,
so I created migration and publish my project with azure app service,
downloaded the publish profile and selected it,
connected to database from "Server Explorer>Data Connections" and logged in.
Took my connection string from azure portal and paste it.
It didn't work gave me 500.30 HTTP error, so I tried to publish a project that doesn't need a database connection, that worked fine...
The problem might be connecting to Server Explorer>Azure>SQL Databases.Because I cant connect to database recieving this error:
Databases for some subscriptions/servers may not be shown in "server explorer".Failed to retrieve server data for subscription. Error message: The azure sql db service management api surface has been depracated.
{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(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anurag Sharma 17,606 Reputation points2020-11-03T05:17:42.123+00:00 Hi @Kutay Yalçıner , welcome to Microsoft Q&A forum.
We are looking into it and get back to you at the earliest.
-
![](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(25.6, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KalyanChanumolu-MSFT 8,321 Reputation points2020-11-03T06:54:02.437+00:00 @Kutay Yalçıner Please check the following to narrow down on the potential issue
- Navigate to "Diagnose and solve problems" blade on your App service to diagnose issues.
- If you do not have Application Insights integration enabled already, please do so from the "Application Insights" blade on you App Service. This will help you capture the exact error/exception from your code while running on Azure.
If you are unable to figure out the issue, please provide few more details to troubleshoot this further.
- What language/framework is your code written in (C#, .NetCore etc)
- When the API works fine on your local computer, is it still connecting to the Azure SQL Database?
- How are you passing the connection string to the app service? (settings.json/environment variable)
Sign in to comment
Sign in to answer