 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / ASP.NET / General / November 2007NT AUTHORITY/NETWORK SERVICE
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 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, Juan T. Llibre, asp.net MVP asp.net faq : http://asp.net.do/faq/ foros de asp.net, en español : http://asp.net.do/foros/ ====================================== > 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. [quoted text clipped - 4 lines] > > Gary 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?  SignatureRegards, Gary Blakely > re: > !> I'm working on a client's server2003 system now that is running [quoted text clipped - 79 lines] >> >> Gary 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. Juan T. Llibre, asp.net MVP asp.net faq : http://asp.net.do/faq/ foros de asp.net, en español : http://asp.net.do/foros/ ====================================== >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? [quoted text clipped - 69 lines] >>> >>> Gary 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" ?? SignatureRegards, Gary Blakely > Gary, > [quoted text clipped - 94 lines] >>>> >>>> Gary Juan, Sorry - I picked the wrong dialog box. Your solution worked fine. Thank you so much! SignatureRegards, Gary Blakely -- Regards, Gary Blakely Dean Blakely & Associates www.deanblakely.com > Gary, > [quoted text clipped - 94 lines] >>>> >>>> Gary 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! Juan T. Llibre, asp.net MVP asp.net faq : http://asp.net.do/faq/ foros de asp.net, en español : http://asp.net.do/foros/ ====================================== > Juan, > Sorry - I picked the wrong dialog box. Your solution worked fine. Thank you so much! [quoted text clipped - 82 lines] >>>>> >>>>> Gary Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.