Here's a description of my setup:
That solution fixed the specific problem I was having, but every time I try to access a different part of Northwind I have to specifically grant permissions. For instance, I just got this error:
SELECT permission denied on object "Product Sales for 1997', database 'Northwind', owner 'dbo'.
I typed this:
osql -E -S (local)\BasicDB -d Northwind -Q "grant select on Product Sales for 1997 to [COMPUTER_NAME\ASPNET]"
Apparently there's some syntax error here...but the problem is bigger than this...the problem is that I shouldn't have to specifically grant permission for every part of the database. What's going on here?