deploying App to 2003 server with SQL2005

I devloped this app with vs2005 and SQL 2005 express, everything seems to work fine, when I deploied the app to my web server I got a few different error messages that I worked through but now stuck on this one. i am sure it is something with SQL 2005 server. is there anywhere that has a good check list for doing things right in asp and SQL deployment?

here is the error message i am getting from debugging.

The SELECT permission was denied on the object 'Categories', database 'Blog', schema 'dbo'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The SELECT permission was denied on the object 'Categories', database 'Blog', schema 'dbo'.

Source Error:

Line 33: SqlConnection connection = CreateConnection();
Line 34: SqlCommand command = CreateCommand(connection, query, parameters);
Line 35: SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
Line 36:
Line 37: Type datatype = factory.GetDataType();

Source File: c:\Inetpub\blogplankroad\App_Code\Utilities\SqlDatabase.cs Line: 35

Hi Planker,

Just as the exception message describes, the user account you're using to connect to the database does not have permission to perform a SELECT on the certain table.

In the SQL Server Management Studio, please open the user property window and grant the proper permission for the user.

HTH. If this does not answer you question, please feel free to mark it as Not Answered and post your reply. Thanks!