I've got an ASP.NET website, and its connecting to a database I've created on SQL Server 2k8 and I'm using windows integrated security on my connection string between asp.net and SQL Server.
What account should I give permissions to my database inside SQL Server? Should I give NT AUTHORITY\NETWORK SERVICE permission to my database?
Right now, I right clicked the network service account, and went to properties, and then I checked my database under "users mapped to this login:" and then in the "database role membership for" diaglogue I then selected public and db_owner. Is that right?
View Complete Post