To solve this problem we need to change the application pool's identity.
You can change the ApplicationPoolIdentity from IIS7 -> Application Pools -> Advanced Settings.
Under ApplicationPoolIdentity you will find local system. This will make your application run under
NT AUTHORITY\SYSTEM, which is an existing login for the database by default.