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

Source: Internet
Author: User
Tags management studio sql server management sql server management studio

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

Related Article

Cloud Intelligence Leading the Digital Future

Alibaba Cloud ACtivate Online Conference, Nov. 20th & 21st, 2019 (UTC+08)

Register Now >

Starter Package

SSD Cloud server and data transfer for only $2.50 a month

Get Started >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.