LOGIN FAILED for USER xxx\ASPNET

Discussion in 'ASP .Net Security' started by Steve Caliendo, Jan 21, 2004.

  1. 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
     
    Steve Caliendo, Jan 21, 2004
    #1
    1. Advertisements

  2. 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.

    --
    Chris Jackson
    Software Engineer
    Microsoft MVP - Windows Client
    Windows XP Associate Expert
    --
    More people read the newsgroups than read my email.
    Reply to the newsgroup for a faster response.
    (Control-G using Outlook Express)
    --

    "Steve Caliendo" <> wrote in message
    news:...
    > 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, Jan 21, 2004
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Åukasz Ligowski

    "xxx.has_key(a)" vs "a in xxx"

    Åukasz Ligowski, Oct 30, 2008, in forum: Python
    Replies:
    0
    Views:
    334
    Åukasz Ligowski
    Oct 30, 2008
  2. Tony Johansson
    Replies:
    3
    Views:
    16,714
    Patrice
    Jan 2, 2010
  3. Replies:
    0
    Views:
    1,150
  4. Bert Leu

    value of type "xxx" cannot be converted to "xxx"

    Bert Leu, Jun 5, 2007, in forum: ASP .Net Web Services
    Replies:
    2
    Views:
    362
    Jesse Houwing
    Jun 6, 2007
  5. Richard Lionheart
    Replies:
    4
    Views:
    322
    Richard Lionheart
    May 5, 2004
Loading...

Share This Page