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

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

Aidan Waterford 0

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

Anonymous

2024-11-19T08:09:22.1933333+00:00

Hi @Aidan Waterford,

Please try to add TrustServerCertificate=True; in your connection string. And tell us the test result.

And I recommend you can copy the database connection string from azure portal.

Best Regards

Jason

1 answer

Your answer

Anonymous

2024-11-19T08:09:22.1933333+00:00

Hi @Aidan Waterford,

Please try to add TrustServerCertificate=True; in your connection string. And tell us the test result.

And I recommend you can copy the database connection string from azure portal.

Best Regards

Jason

Answer 1

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

2 deleted comments

Comments have been turned off. Learn more