Why doesn't individual account authorization work after deploying Blazor Server app to Azure?

Donnie Console 26 Reputation points
2022-06-13T23:17:46.647+00:00

I recently deployed my Blazor Server app (.net6) to Azure web app, but when I try to use the authorization login, it says there was an error. I can only assume it's timing out when looking for the auth database since it only ever gets created on my local machine. Is there a way to migrate that db to azureSQL? I looked around but could not find any resources detailing this exact issue. Thanks for the help!

Azure SQL Database
Blazor
Blazor
A free and open-source web framework that enables developers to create web apps using C# and HTML being developed by Microsoft.
1,385 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,863 questions
0 comments No comments
{count} vote

Accepted answer
  1. Bruce (SqlWork.com) 55,601 Reputation points
    2022-06-14T02:35:54.997+00:00

    The default database is localdb. Localdb is not a supported on servers and will not work in a webfarm, pick an azure database of you choice, and deploy to that database and update your connection settings. See data mitigations for a possible deployment.


2 additional answers

Sort by: Most helpful
  1. Bruce (SqlWork.com) 55,601 Reputation points
    2022-06-14T15:51:06.69+00:00

  2. Shaun O'Reilly 0 Reputation points
    2023-04-28T10:10:25.6433333+00:00

    I have created and migrated my Azure SQL server, but still not Authorizing.

    What else needs to be in place?

    0 comments No comments