Microsoft.Data.SqlClient.SqlException: 'Could not find stored procedure 'FoundationConfiguration_List'.'

[YogeshLTI]

Describe the bug
Microsoft.Data.SqlClient.SqlException: 'Could not find stored procedure 'FoundationConfiguration_List'.'

To Reproduce
i have installed foundation code in visual studio 2022 and created database through below commands

1. dotnet-episerver create-cms-database Foundation.csproj -S servername -U sa -P "sa"
2. dotnet-episerver create-commerce-database Foundation.csproj -S servername -U sa -P "sa"

when i run the solution locally on my machine i m getting below errors , dont know whow to resolve this

error : Microsoft.Data.SqlClient.SqlException: 'Could not find stored procedure 'FoundationConfiguration_List'.'

Please help

[akfo]

Have you executed the setup.cmd file (or setup.sh file) located in the root of the Foundation project? This file does different things, but one of the tasks is to create database elements.

[Segimara]

Hi, have same issue, i used setup.cmd and resetup.cmd multiple times but still same issue

[CharcoalStyles]

I'm having this issue, too.

Running it on a Mac with Docker. Runinning the setup.sh file seems to work fine, but when I go to run the application, it shows this error message:
Unhandled exception. EPiServer.Framework.Initialization.InitializationException: Initialize action failed for Initialize on class Foundation.Infrastructure.InitializeSite, Foundation, Version=2021.4.1.0, Culture=neutral, PublicKeyToken=null ---> Microsoft.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'FoundationConfiguration_List'.