Unable to open the database requested by login "XXXX". Login failed. User ' NT authority\system ' login failed.

The user ' IIS Apppool\defaultapppool ' logon failed.
I have IIS installed in the WINDOWS8
Then I added the website I made.
Prompt user ' IIS Apppool\defaultapppool ' logon failed after opening.

I can run normally in vs2010.
Best answer this is a setup issue for setting up IIS application pools.
I was confronted with such a problem.

For example, my site named MyWeb, will default to you to create a myweb application pool
HTTP 404.17 error At the beginning of the report

Solution:
1. Right-myweb The application pool, basic settings, select the. NET Framework version, see there are two, 2.0, and 4.0.
Ah, when I see it, I choose 4.0.

And then I'm going to report your mistake.
' IIS apppool\defaultapppool ' login failed.
This is because the user authentication mode of your IIS application pool differs from the authentication mode of SQL Server. Remember which mode you chose when installing SQL Server? Mine is LocalSystem (if you forget, try each one)
OK, let's solve the problem next.

2. Again right-myweb the application pool, advanced settings, see that there is a node called "Process Model", modify the marked one, for
LocalSystem. Get.

Turn on your website.

Log in to the database with a username and password, add a native name at the location of the security login, and then remember to assign permissions.

For example:

Under "Albums" Database Security > Users > Right click (new user) > Login (SELECT ' NT authority/system ') > then select the corresponding role member (note permissions), OK, OK. It's OK.
Note that to add user mappings to a user under Database > logins, the steps are: Right-click on the user name > Properties > User Mappings > Put the right-hand database "Albums" on the hook. Are you sure.

SELECT permission denied to object ' base_config ' (database ' * * * ', schema ' dbo ')

The database used here is version 08, and this has been reported as a permission error: the error is as follows:

See the effect Description: In the case of Windows authentication log in to the database table can be opened, when the switch to SA or another account login in the time we click on our database will be error:

Here's how to fix it:

1, first we have to use the Windows identity login to set up, because your SA and other account login settings are invalid "This step is very important."

2, find the corresponding library security---the framework->dbo-> right-click Properties "Permissions", Search, "public", OK, on the right with authorization, if you do not know the case of all the hook can be. Refer to the following:

3, if this time still use SA or other account can login, go in after right-click Edit Table Error, then this time you need to make the following settings.

4, Windows login to select Table Right-click Properties "Permissions", Search, browse "public", OK, on the right with authorization, if you do not know the case of all hook can be. Refer to the following

Finally the perfect solution to the problem. The effect is as follows:

Perfect solution, off duty.

Unable to open the database requested by login "XXXX". Login failed. User ' NT authority\system ' login failed.