Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Posts
    3

    Unanswered: login failed for user

    I have XP Pro installed with SQl Server 7.0. I use Visual
    Studio.NET for programming ASP.NET(IIS is also
    installed).When I run this, I get an error message

    "login failed for user VENKY/ASPNET".

    I did some search and many poeple seem to have these
    errors but not one page says what is to be clearly done
    for XP platform. One page said that I have to create a
    domain user ASPNET and see to that this user has access
    rights to SQL Server. COuld someone please tell the steps
    to do this. Thanks a lot in advance.

    Gayathri
    .

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Is your sql server and iis running on the same machine ? What is your anonymous login set to under iis ?

  3. #3
    Join Date
    Dec 2002
    Posts
    3
    Originally posted by rnealejr
    Is your sql server and iis running on the same machine ? What is your anonymous login set to under iis ?

    Yes they are running on the same machine. Sorry what do you mean by anonymous login, where do you go and see that. Anyway yesterday we solved the problem somehow, did further research on the web and somehow solved it.

    Thanks,

    Gayathri

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    To check the anonymous account used in iis - go into internet service manager. Right click on 'default web site'. Click on 'directory security' -> click edit under 'anonymous access ...) -> click edit under 'anonymous access'.

    The solution may have been adding that username to sql server or the anonymous access login to sql server.

    For future reference - the following is a helpful article from ms:

    article

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •