Getting error when retrieve data from database.

Deepak M

Hello,

I have an web api application which is working perfectly when i run the application. But getting error when deploy it in IIS.
Error: The maximum number of retries (6) was exceeded while executing database operations with 'SqlServerRetryingExecutionStrategy'. See the inner exception for the most recent failure.
Don't konw why I am getting this error. Can anyone help?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty3y ago
Accepted answer
Don't know it will work for you or not. If 'NT AUTHORITY\SYSTEM' is not set to sysadmin role will cause some inner exception because in your local it's working but in IIS not. So run the below query and try. This may help you.
```
EXEC master..sp_addsrvrolemember @loginame = N'NT AUTHORITY\SYSTEM', @rolename = N'sysadmin'
```
+3
Deepak M3y ago
It worked. Thank you @Amit
+1
Deepak M3y ago
@Naresh, I am using Sql Server database not Cosmos. And already go through the provided link.
+1
Naresh Beniwal3y ago
https://stackoverflow.com/questions/58454224/maximum-number-of-retries-6-exceeded-while-executing-database-operations-with
0