On my development machine, I often create new web instances that all run as NT AUTHORITY\NETWORK SERVICE. I want to grant this account rights to access all new databases that I create in the future in my SQL Server 2008 R2 instance. I want to do this because it is too much of a hassle to grant rights to new databases every time I create a new web site.

  • @Kin This works. Should I remove the question? Commented Sep 17, 2015 at 15:00
  • Please leave it .. no need to delete. Thanks !
    – Kin Shah
    Commented Sep 17, 2015 at 15:24

1 Answer 1


Well - there is a bigger question regarding why you are using NT Authority\Network, but I asked a similar question ages ago Permissions on New Databases So in theory, it is fairly simple.

  • Thank you, I'm checking out the other question. Is there any problem with using NETWORK SERVICE as the identity of my IIS application pools? Commented Sep 17, 2015 at 14:56

Not the answer you're looking for? Browse other questions tagged or ask your own question.