login failed

I know this is probably a question that has been answered a million times, but it is in regard to SQLEXPRESS. I have built a small ASP 2.0 web app that runs fine on the local production machine when I go to view a gridview or a detailsview to delete or add records. However, when I try the site out on another machine, it runs fine (logins, etc), however when I go to the data page I get an error stating that the login failed for the ASPNET account.

In SQLEXPRESS, where do I set the permission for the ASPNET account, or how do I go about handling this?

Thanks for the information.

Brad

[596 byte] By [guyinkalamazoo] at [2008-2-13]
# 1
Just some other information as I have not yet found an answer to this problem - I am using SQLEXPRESS (as stated in the prior post) and IIS 5.1 for other tables. I can using the login controls just fine. I can add users, etc. I created a new database in SQLEXPRESS and it is the tables to this database that I am having a problem with.

Thanks for the help.

Brad

guyinkalamazoo at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Security...
# 2
Okay, the only Express Manager and grant dbo rights to ASPNET. If there is a better way for this, please let me know because I don't know if it is safe to give those rights to this account.

Brad

guyinkalamazoo at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Security...
# 3
Are remote connections enabled for SQL Express? Can you connect remotely at all? You can check if remote connections are enabled using the Surface Area Configuration tool.

What is the login failure error message in the SQL Express error log?

What is the version of SQL Express that you are using?

Thanks
Laurentiu

LaurentiuCristofor at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Security...

SQL Server

Site Classified