ASPNET Select permission denied...

I programmed my web using VS.Net 2005 with the a website as a file system and Database as system wide(as in not using the dynamic attach method) SQL 2005 DB.
I had no problem during development. Finally, I published my web and I get the following error:

SELECT permission denied on object ....

My connection string is:
<add name="defaultSqlServer" connectionString="Server=.;Integrated Security=SSPI;Database=MetaBase" providerName="System.Data.SqlClient"/>
or
<add name="defaultSqlServer" connectionString="Server=.;Integrated Security=True;Database=MetaBase" providerName="System.Data.SqlClient"/>
Both work before publishing.
The aspnet login is successful, but that error occurs with any other kind of db access. So I set the ASPNET account to have grant access to all permissions and dbo as the Grantor, but I still get that error. I have confirmed that the actual user is ASPNET via the SQL Profiler.
Any help would be appeciated.

Thanks in advance,
Donald Adams


.