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


Answer this question

login failed

  • Harry1311

    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

  • Rodrigo Silva

    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

  • devudu

    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

  • login failed