How to make EF code first work under `IIS AppPool\MySiteName`?

Question

I am learning MVC 3 from asp.net site.

My MVC 3 application already has been tested under IIS AppPool\MySiteName and it works well.

Using Sql Server Management Studio, I created a new account for IIS AppPool\MySiteName.

I followed this tutorial "creating db on the fly" and I got an error as follows:

Server Error in '/' Application.
--------------------------------------------------------------------------------

Cannot open database "Movies" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\Getting Started'. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Answer 1

Well that error is saying that the user IIS APPPOOL\Getting Started doesn't have the proper login credentials, either your username or password is incorrect. Why not show us what the connection string looks like in your web.config file