I''m trying to get my asp.net/sql server2005 app running under IIS 6. The DB connection is working fine in visual studio environment, but when I try and access the DB through localhost, it crashes, saying that NT AUTHORITY\NETWORK SERVICE is not a valid login.
I grant access to the NT Authority user using the following code:
exec sp_grantlogin N'NT AUTHORITY\NETWORK SERVICE'
exec sp_grantdbaccess N'NT AUTHORITY\NETWORK SERVICE'
and then the login error stops. BUT, now it throws an error saying that the stored procedure 'x' doesn't exist. The sproc clearly exists, and I've confirmed that it's still attempting to access the correct DB. Do I also have to grant access to the SPROCS?
Any insight is appreciated.