How to publish a blazor website with sql sever that is giving the error HTTP Error 500.30 - ASP.NET Core app failed to start

Question

hi,

im trying to publish my blazor web app on azure however it fives me the error HTTP Error 500.30 - ASP.NET Core app failed to start. when i try to debug it and go into the diagnose page of the websever i get this error Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open server "aidandwaterfordgmail.onmicrosoft.com" requested by the login. The login failed. how do i fix it?

ps i have changed fire wall setting as the connection string works on my local matchine

Answer 1

Hi @Aidan Waterford,
Welcome to the Microsoft Q&A Platform!
The error indicates a problem with your Blazor app's database connection. Specifically, the SQL Server cannot authenticate the login request for the user account specified in the connection string when the app is running on Azure.
Check the Connection String

Server=tcp:<your-server-name>.database.windows.net,1433;
Initial Catalog=<your-database-name>;
Persist Security Info=False;
User ID=<your-username>;
Password=<your-password>;
MultipleActiveResultSets=False;
Encrypt=True;
TrustServerCertificate=False;
Connection Timeout=30;

Incorrect Authentication Method: The connection string is using an Azure AD login, but the SQL Server may not be configured to accept Azure AD authentication.

Firewall Misconfiguration: Although the firewall is set, ensure that "Allow Azure services and resources to access this server" is enabled in the Azure SQL Server settings.

Mismatched Connection String: The connection string that works locally may not be valid for Azure if it uses Integrated Security or local credentials.
If the answer is helpful, please click "Accept Answer" and kindly upvote it.