Error:
The EXECUTE permission was denied on the object 'StoredProcedureTest1', database 'testDb1', schema 'dbo'.
ClientConnectionId:c48bf98e-e0ca-40f5-8ee9-8cd15b238d8a
Error Number:229,State:5,Class:14
"ConnectionStrings": {
"DefaultConnection": "Server=xyzServer;Database=testDb1;User Id=sa;Password=abcd..;Trusted_Connection=True;MultipleActiveResultSets=true;TrustServerCertificate=True;"
}
Solution:
if sql server connection is Windows authentication then use Trusted_Connection=True
if sql server connection is SQL Server authentication then use Trusted_Connection=False