When logging into the database and the Web Server and Database Server are part of the same machine, a user may receive the error:
Unable to connect to database 'Local Data'. Check web.config settings. The error was: Cannot open database '<Database Name>' requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.