LOGIN FAILED for USER xxx\ASPNET

[Steve Caliendo]

Hi,

I can generate a dataset just fine in design mode using a SQL server that's
on my computer, but when I launch it, the ASPNET user can't access my
database. I've made the ASPNET user on my computer be an administrator, but
that didn't work. What do I need to change to allow this user to access my
database ?

Thanks,

Steve

 

[Chris Jackson]

Go into SQL Server and add an account with that user name, giving it
permissions to that database. An even better option is to use impersonation
in your ASP.NET application, giving it a low-permissions domain account to
use for database authentication.