Adding NETWORKSERVICE as a dbo user in SQL Server
January 03, 2014
If you want to enable integrated security in your SQL Server connection string, and don’t want to have to update your App Pool with a username across different machines you can simply add ‘NT AUTHORITY\NETWORK SERVICE’ as a dbo for the database you’re querying.
You can also add “NT AUTHORITY\LOCAL SERVICE” too.
Obviously this isn’t recommended for production use, and shouldn’t really be used in larger teams or multi-environments (staging, live-staging, live) setups.