SQL Server 2005 - how do i create the ASPNET user?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • SpaceMarine
    #1

    SQL Server 2005 - how do i create the ASPNET user?

    ok im new to SQL Server 2005, from 2000.

    my webapps use integrated security, and run under:

    \\MYMACHINE\ASP NET

    ....in 2000 it was a pretty simple thing to create a new db user for
    this user. took 10 seconds to click thru and do it.

    but in SQL 2005, i just cant seem to figure it out. in the Management
    Studio i go to the Security->User folder and try to add a new user..
    but when i browse around for \\MYMACHINE\ASP NET, i just cant find it
    anywhere.

    am i going about this incorrectly?


    thanks!
    sm
    Tags: None
    • SpaceMarine
      #2
      Re: SQL Server 2005 - how do i create the ASPNET user?

      On Feb 18, 10:35 am, SpaceMarine <spacemar...@ma ilinator.comwro te:
      well, running this sql sorta worked:
      >
      CREATE USER [ASPNET] FOR LOGIN [MYMACHINE\ASPNE T]
      >
      ...but my app still returns the beloved "Login failed for user
      'MYMACHINE\ASPN ET'" error when i run it via IIS. (if i run it via
      VS.NET 2005's internal web server, it works).
      >
      still trying to figure it out.
      got it -- i had to create the *login* in the database's Security
      section, and then i could create a *user* based on that login.

      no mo' error.


      sm

        Comment

        • Lars
          #3
          Re: SQL Server 2005 - how do i create the ASPNET user?

          Hi

          You do it from the Visual Studio environment.

          For Visual Studio 2008/2005
          Simply you open a page on the site you are creating and from that page you
          can add, manage and delete users and roles. I don't know how you reach this
          site from outside the IDE. But I think you have to edit the database
          ASPNETDB.MDF to add users and roles (I guess).

          Check out the free instruction video from www.LearnVisualStudio.net . It's
          awesome.

          http://www.learnvisualstudio.net/content/Samples/vwd_09cs.htm



          Lars


          "SpaceMarin e" <spacemarine@ma ilinator.comskr ev i meddelandet
          news:c6f514da-2f8e-4108-bf18-3e8bef5b51e9@z1 7g2000hsg.googl egroups.com...
          On Feb 18, 10:35 am, SpaceMarine <spacemar...@ma ilinator.comwro te:
          well, running this sql sorta worked:
          >>
          CREATE USER [ASPNET] FOR LOGIN [MYMACHINE\ASPNE T]
          >>
          ...but my app still returns the beloved "Login failed for user
          'MYMACHINE\ASPN ET'" error when i run it via IIS. (if i run it via
          VS.NET 2005's internal web server, it works).
          >>
          still trying to figure it out.
          >
          got it -- i had to create the *login* in the database's Security
          section, and then i could create a *user* based on that login.
          >
          no mo' error.
          >
          >
          sm

            Comment

            Previous template Next
            Working...