Database unreachable, user NT Authority/system or NT AUTHORITY\NETWORK SERVICE login failure Resolution

Issue: In IIS 7.0 in Win7, hang a virtual directory under the default Web Site directory. Set the identity set to NetworkService in the appropriate application pool DefaultAppPool.

However, after the page is opened, unable to open the database requested by the login, the user logon NT AUTHORITY\NETWORK Service failed.

Workaround:

1. Open SQL Server Management Studio, create a new registration name network SERVICE under Security-login, and set the default database to the database to be accessed.

2. Then select the server role (note permissions).

3, in the user mapping to the right of the database to access the hook, the following increase access to the database, role members selected Db_owner,public.

If you can not log in to the database using NT Authority/system, only need to login under the NT Authority/system right-click Property, User Mapping-tick the database you want to access, role members select Db_owner,public.

Database unreachable, user NT Authority/system or NT AUTHORITY\NETWORK SERVICE login failure Resolution