.Net, IIS, SQL Server [Solved] Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\LOCAL SERVICE’ To solve this issue we need to add LOCAL SERVICE to the database, by doing this, we can solve this issue in few seconds March 2, 2021 2Microsoft SQL Server
.Net, ASP.NET, IIS, SQL Server [Solved] Cannot open database requested by the login. The login failed. Login failed for user IIS APPPOOL To solve this issue we need to change the identity in the IIS, by doing this, we can solve this issue in few seconds March 1, 2021Microsoft SQL Server
.Net, ASP.NET, Entity Framework, SQL Server [Solved] Microsoft.Data.SqlClient.SqlException (0x80131904): The INSERT permission was denied on the object, database, schema ‘dbo’ Simplest way to solve this error is just to grant permission to Insert, select, update and delete. This issue can be resolved in few seconds March 1, 2021Microsoft SQL Server
SQL Server [Solved] ‘OPTIMIZE_FOR_SEQUENTIAL_KEY’ is not a recognized CREATE TABLE option This issue is very easy to solve and we can able to solve this issue within few seconds. This issue occurs we run SQL scripts in a different version of SQL Server. February 27, 2021 1Microsoft SQL Server
SQL Server [Solved] Drop failed for Database (Microsoft.SqlServer.Smo) There is an option where this issue can be resolved within a second. Well, I am sharing a solution to close this problem in few seconds. February 27, 2021Microsoft SQL Server