Posted on Friday January 3, 2014

Adding NETWORKSERVICE as a dbo user in SQL Server

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.