By default, SQL Server denies access to user accounts that don't have explicit access to a database, a table, or a view. And by default, ASP.NET applications run in the context of the ASPNET user account. Unless you permit access to the ASPNET user account, an ASP.NET application can't read or update data in a SQL Server database. The Microsoft article "HOW TO: Configure SQL Server Security for .NET Applications" describes the process that you can use to give an ASP.NET application permissions to a SQL Server 2000 database. You can read the article at<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

   http://support.microsoft.com/default.aspx?scid=kb;en-us;815154