NT AUTHORITY/NETWORK SERVICE

GaryDean · Nov 30, 2007

We typically access sqlserver 2005 databases from our asp.net applications
by usine the NT AUTHORITY/NETWORK SERVICE user account on Server2003. It
works fine and keeps us from having to put a UID and PWD in a
connectionstring.

I'm working on a client's server2003 system now that is running Sqlserver
2000 (don't' know if that has anything to do with this issue) and I find
that there is no NT AUTHORITY/NETWORK SERVICE account.

Is the server misconfigured or does this have something to do with sqlserver
2000?

Thanks,

Gary

Juan T. Llibre · Nov 30, 2007

re:
!> I'm working on a client's server2003 system now that is running Sqlserver
!> 2000 (don't' know if that has anything to do with this issue) and I find
!> that there is no NT AUTHORITY/NETWORK SERVICE account.

NT AUTHORITY/NETWORK SERVICE is not listed as a user
( when you open "Manage Your Computer" and scroll down to "Local Users and Groups" and "Users" ).

You can, however, assign permissions to that account.

If you select any directory on your HDD, right-click ane select "Properties";
select the "Security" tab; click "Add"; click "Advanced" and then "Find Now",
you'll see it listed as "NETWORK SERVICE".

By double-clicking it, you can add the account to the accounts which can access the directory.
OK your way out of the dialogs and assign the poermissions you want to assign to it.

Make sureb you don't confuse it with the "NETWORK" account.
That's a different account.

You want the "NETWORK SERVICE" account
....which is the account ASP.NET runs as under W2K3.

If you want to confirm that ASP.NET is running as the "NT AUTHORITY\NETWORK SERVICE" account,
copy this file which I wrote, as "identity.aspx" and run it from any IIS directory :

identity.aspx:
-------------------
<%@ Page Language="VB" %>
<%@ Import NameSpace = System.Security.Principal %>
<script runat="server">
Sub Page_Load()
Dim tmp As String = WindowsIdentity.GetCurrent.Name()
Label1.Text = "ASP.NET is running as the account : " & tmp
End Sub
</script>
<html>
<head>
<title>What account is ASP.NET running as ?</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" Runat="server" Text="Label"></asp:Label>
</div>
</form>
</body>
</html>
-----------------

Unless you are impersonating the account ASP.NET runs as, that will return
"NT AUTHORITY\NETWORK SERVICE" when run in IIS 6.0 in W2K3.

regards,

GaryDean · Nov 30, 2007

I picked a directory and was able to add NETWORK SERVICE ok but when going
back to SQLServer and trying to find NETWORK SERVICE to assign ad db owner
it was still now there. any idea what might be wrong?

Juan T. Llibre · Nov 30, 2007

Gary,

NT AUTHORITY\NETWORK SERVICE doesn't show up for selection
purposes when you try to select a domain account in SQL Server,
but if you write in the account name, it will be accepted.

GaryDean · Nov 30, 2007

After typing it in in the Add Name text box in the SQL Server 2000 new login
dialog box it says...
"The account NT AUTHORITY\NETWORK SERVICE is a well known group account.
The application will not accept well known group accounts"

??

GaryDean · Nov 30, 2007

Juan,
Sorry - I picked the wrong dialog box. Your solution worked fine. Thank
you so much!

Juan T. Llibre · Nov 30, 2007

re:
!> Sorry - I picked the wrong dialog box.

Happens to the best of us.

re:
!> Your solution worked fine.

I'd been there, done that... ;-)

re:
!> Thank you so much!

You're quite welcome.
Glad to know you're up and running!

Consequences of using "nt authority\network service"?	0	Aug 27, 2004
NT AUTHORITY\NETWORK SERVICE error	4	Jun 16, 2006
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'	2	Sep 22, 2007
"NT Authority\Network Service" in Global.asax	4	May 22, 2004
Really Need a Help....The current identity (NT AUTHORITY\NETWORK S	2	Nov 22, 2008
Trusted SQL Connections & NT AUTHORITY\NETWORK SERVICE	3	Mar 1, 2007
Use RunAs command with NT Authority\Network account for DPAPI	1	May 19, 2006
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'	1	Jan 6, 2004

NT AUTHORITY/NETWORK SERVICE

GaryDean

Juan T. Llibre

GaryDean

Juan T. Llibre

GaryDean

GaryDean

Juan T. Llibre

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads