Cannot open database "aspnetdb" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Question

0.00/5 (No votes)

See more:

Good day all, Please can some one help me out here, i am using windows 7 and i have setup my IIS, I installed an application so i can view it on my browser like this localhost/me/default.aspx.
it worked fine, but when ever i want to log in it shows this error

C#

Cannot open database "aspnetdb" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

<pre lang="c#">
// my connection string is this
<connectionStrings>
       <add name="ASPNETDBConnectionString" connectionString="Data Source=localhost;Integrated Security=sspi; initial catalog=aspnetdb; User Instance=False"
            providerName="System.Data.SqlClient" />
    </connectionStrings>

i have gone to C:\inetpub\wwwroot\me, clicked on property, Security, Network Service... I have enabled the Read, Write, and Modify. when I preview it is still showing same Error...
My database is on same folder App_Data..

Please can someone help me out here

Posted 14-Sep-13 18:13pm

Difameg Network Nigeria

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ron Beyer · Answer 1 · 2013-09-14T18:24:00

Solution 1

You need to add the Network Service user to the authorized users in the SQL database.

Posted 14-Sep-13 18:24pm

Ron Beyer

Comments

Difameg Network Nigeria 15-Sep-13 0:37am

Hhow do i do that Please, thanks

Ron Beyer 15-Sep-13 0:41am

You can see this StackOverflow answer to see how to do it. Just run the command in SQL Management Studio.

Difameg Network Nigeria 15-Sep-13 0:50am

thank you, how do i locate the sp_grantlogin i am not using sql server, the database was created using the db insyde visual studio

thanks for your time, i appreciate

Dholakiya Ankit · Answer 2 · 2013-09-15T20:15:00

Under ApplicationPoolIdentity you will find local system. This will make your application run under NT AUTHORITY\SYSTEM, which is an existing login for the database by default.

http://stackoverflow.com/questions/7698286/login-failed-for-user-iis-apppool-asp-net-v4-0[^]

[Edit: noticed the image does not show up properly in R.H.S], So just select Application Pool -> a pool entry -> Advanced Settings... (from Edit Application Pool section) -> Process Model (from Advanced Setting dialog box)

http://forums.asp.net/t/1510479.aspx[^]

http://blog.igorware.com/login-failed-for-user-iis/[^]

http://www.aspdotnet-suresh.com/2011/05/systemdatasqlclientsqlexception-login.html[^]

just the matter is you have the user which does not have authority to use the database,......:)