When running on Azure sql, Invalid object name OpenIddictApplications

episerver / Foundation

Foundation offers a starting point that is intuitive, well-structured and modular allowing developers to explore CMS, Commerce, Personalization, Search and Navigation, Data Platform and Experimentation.

https://docs.developers.optimizely.com/digital-experience-platform/docs/optimizely-foundation-demo-sites

Apache License 2.0

132 stars 136 forks source link

When running on Azure sql, Invalid object name OpenIddictApplications #882

Closed ashishgururani1 closed 1 year ago

ashishgururani1 commented 1 year ago

So, I downloaded the application. Followed the documentation to run setup.cmd and everything runs on local. Then I moved the 2 cms and commerce databases to Azure sql. Changed the connection string on my local to run the app and I am greeted with the following. (yes, the database on azure are ip whitelisted)

Microsoft.Data.SqlClient.SqlException: 'Invalid object name 'OpenIddictApplications'.'

Can the application run on azure? I have't even moved the application to WebApps yet.

lunchin commented 1 year ago

This was fixed in recent version of OpenConnect package.