Monday, October 12, 2026

When web application with sql server connection using sql client, working in visual studio but not working in localhost as in iis

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

No comments:

Post a Comment

When web application with sql server connection using sql client, working in visual studio but not working in localhost as in iis

Error:  The EXECUTE permission was denied on the object 'StoredProcedureTest1', database 'testDb1', schema 'dbo'.  C...