how to change default sql user account

Topics: ASP.NET 2.0
Mar 30, 2010 at 6:03 PM

I'm trying to configure sql support on a server running 2003 server.  It's a domain controller that uses active directory - which means I can't gain access to the NT AUTHORITY\NETWORK SERVICE account to grant access.  I need to run the service as a local account  like domain\someuser.  I'm not sure how to configure the service to do this.  What changes do I need to make to the config file or IIs - if anyone can help I'd really appreciate it.

Mar 30, 2010 at 8:15 PM

I actually figured this out and figured I'd post the fix if any one stumbles upon this and has the same trouble as me.  If you want, or need to run the asp service as a local user, you can edit the config file to contain: <identity impersonate="true" userName="xx" password="xx"/> - this can be put anywhere inside of the <system.web> tags.  You would want to store the pw info in the registry and hide it in the config  file though - unless it's just for development. I created a low level account just for this.