Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 7 of 7
  1. #1
    Regular Coder
    Join Date
    Jun 2002
    Posts
    406
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to setup ASPNET user account?

    I created an application (application name: ContactManagement) and compiled and every thing was fine. When I loaded in IE, I got the following error:

    Login failed for user 'CHELVI\ASPNET'.
    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'CHELVI\ASPNET'.

    When I look at the URL of this error page: http://localhost/ContactManagement/SwitchBoard.aspx

    So one of my friend told me I have to setup the user ASPNET from the control panel. But I couldnt find it.
    Can some one know how to do this and help me?

  • #2
    teh Moderatorinator
    Join Date
    Sep 2004
    Location
    USA
    Posts
    2,472
    Thanks
    4
    Thanked 40 Times in 40 Posts
    You need to add the aspnet account in sql server:
    http://weblogs.asp.net/coltk/archive...7/10/9920.aspx

  • #3
    Regular Coder
    Join Date
    May 2006
    Posts
    181
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by chelvis
    But I couldnt find it. Can some one know how to do this and help me?
    Did you try what I provided to you the other day:
    Can't figure out this error!

    Here is once again:
    1. Open SQL Server Enterprise Manager
    2. Expand CHELVI\NETSDK
    3. Expand Databases
    4. Expand the database (the one you try to connect)
    5. Right-click on Users + New database user...
    6. Use the drop-down list to select the Login name: CHELVI\ASPNET
    7. Tick public and db_owner
    8. Click "OK"

    If on step #6 you don't see CHELVI\ASPNET in the drop-down menu, use the following directives instead:
    1. In Enterprise Manager
    2. Expand CHELVI\NETSDK again
    3. Expand Security
    4. Right click on "Logins" and click on "new login..."
    5. You will see a top menu with 3 tabs, from the "General" tab, Windows Authentication will be already tick
    6. Domain: select CHELVI from the drop down menu
    7. Name: you will see CHELVI in the textbox, now click the button at the right of that textbox
    8. From the menu select "ASPNET(ASP.NET Machine Account...)"
    9. Click on "Add" and "OK"
    10. Now select "Database Access" from the top tabs menu
    11. Tick your database
    12. Tick "db_owner" and "public"
    13. Click "OK"
    Last edited by otaku149; 06-23-2006 at 03:39 AM.

  • #4
    Regular Coder
    Join Date
    Jun 2002
    Posts
    406
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks so much for your help otaku149. I got it and now I can run my application. I appreciate it. Yeh, the other day I tried and I couldnt find what you mentioned. Now its working because the second part you provided is the one I tried and worked.
    Last edited by chelvis; 06-23-2006 at 03:42 PM.

  • #5
    Regular Coder
    Join Date
    May 2006
    Posts
    181
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by chelvis
    Thanks so much for your help otaku149. I got it and now I can run my application. I appreciate it.
    You're welcome chelvis
    Quote Originally Posted by chelvis
    Yeh, the other day I tried and I couldnt find what you mentioned. Now its working because the second part you provided is the one I tried and worked.
    That's what I thought reading this current thread. Just let me know next time when I provide to you some help and you face some problems, that way I will be able to help you.

  • #6
    Nik
    Nik is offline
    New to the CF scene
    Join Date
    Jul 2006
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to setup ASPNET user account

    Hi,

    I have same problem with SQL Server 2005.I cant create ASPNET user in 2005.

    Please help,

    Thanks,
    Nik

  • #7
    Regular Coder
    Join Date
    Jun 2002
    Posts
    406
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You have to follow the steps otaku149 said earlier. If you follow one of them, the problem should get solved.


  •  

    Posting Permissions

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