HELLO ALL,

I AM CREATING A WEBSITE THAT WILL REQUIRE A USER TO LOGIN INTO AN ADMIN SECTION OF THE WEBSITE. I HAVE READ ALL THE POST CONCERNING PERSONAL WEBSITE STARTER KIT, CLUB.SQL ALL OF THAT. i HAVE MY SQL SERVER SCHEMA SETUP AND GETTING CONNECTIVITY. HOWEVER, WHEN I LOGIN WITH USERNAME AND PASSWORD I GET INCORRECT PASSWORD.

I HAVE USED ALL THE SCRIPTS FOR ASPNET_USERS, ASPNET_MEMBERROLES, ROLEIDS ETC..

WHERE DO YOU SETUP YOUR PASSWORD. IT WORKS ON MY COMPUTER FINE UNDER WEBSITE CONFIGURATION -SECURITY...

IS THE PASSWORD IN A FILE  SOMEWHERE THAT HAS TO BE COPIED..

 HELP...

 THANKS

What you will need to do is make sure that you are pointing to the production database in your web.config file for the application. This way when you use ASP Configuration it is pointing to your database on GoDaddy and you will be able to add users etc. This of course is all depending if GoDaddy allows remote connections to the database. You may want to look through their support docs to see if there is any special configuration you may need to do in order to implement Membership. Not all hosts have it configured the same way and GoDaddy seemed to be a problem for me when I tried to implement Membership for a previous customer of mine. I hope this helps...

 dapanther99

GoDaddy does not allow remote access to their databases, you will have to create a small application that creates your initial administative account and roles if using them. Then you can delete that application and publish your website and you will then be able to login.

Hi syrus-intl, all passwords(encrypted or clear) of created memberhsip users are stored in the aspnet_Membership table in the membership database, and there are two stored procedures for retrieving user password: aspnet_Membership_GetPassword and aspnet_Membership_GetPassword. 

I'd like to know which database you're using when the website has been upload to the GODADDY host? Firstly you need to configure your membership provider point to the right database, for this please refer to:
Configuring ASP.NET 2.0 Application Services to use SQL Server 2000 or SQL Server 2005

Besides this, you should also make sure the applicationName attribute for each provider defined in web.configure has been set to proper value, for more information please refer to:
Always set the "applicationName" property when configuring ASP.NET 2.0 Membership and other Providers

Still having problems..before i was getting invalid password.. now i  get errors.. Link to my website is

http://www.greathomesbylj.com/login.aspx

Here is my login.. At this point I dont care.. I will change it once i get it working..

username =  bchambers
password  = aaliyah!

Also, On my Godaddy SQL Server, I have information in my Role_id, Users but nothign in my aspnet_membership How do i add this information.. I copied my entire site but it stills does nothing..

  <connectionStrings>
    <add name="ConnectionString" providerName="System.Data.SqlClient"
         connectionString="server=whsql-v07.prod.mesa1.secureserver.net;
                         database=DB_xxxxxx;
                         uid=xxxxxxx;
                         pwd=xxxxxx"/>
    <remove name="LocalSqlServer"/>
    <add name="LocalSqlServer" providerName="System.Data.SqlClient"
          connectionString="server=xxxxxxxx.secureserver.net;
                         database=DB_xxxxxxx;
                         uid=xxxxxxx;
                         pwd=xxxxx"/>
  </connectionStrings>
  <system.web>
    <!--
            Set compilation debug="true" to insert debugging
            symbols into the compiled page. Because this
            affects performance, set this value to true only
           during development.
            Visual Basic options:
            Set strict="true" to disallow all data type conversions
            where data loss can occur.
            Set explicit="true" to force declaration of all variables.
        -->
    <membership>
      <providers>
        <clear/>
        <add name="AspNetSqlMembershipProvider"
         type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
         connectionStringName="LocalSqlServer"
          enablePasswordRetrieval="false"
          enablePasswordReset="true"
          requiresQuestionAndAnswer="true"
          requiresUniqueEmail="false"
          passwordFormat="Hashed"
          maxInvalidPasswordAttempts="5"
          minRequiredPasswordLength="25"
          minRequiredNonalphanumericCharacters="1"
          passwordAttemptWindow="10"
          passwordStrengthRegularExpression=""
          applicationName="/"/>
      </providers>
    </membership>
    <roleManager enabled="true">
      <providers>
        <add name="AspNetSqlRoleProvider" connectionStringName="myConnectionString" applicationName="/"
        type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
      </providers>
    </roleManager>

Can you shut off your custom errors so we can see what your error is?

<

customErrors mode="Off"/>

It is off

Ok.. I am now back to square one. But i have noticed that there is nothing in the godaddys aspnet_membership table.. How do i copy what i have over to there DB...

ApplicationId

UserId

Password

PasswordFormat

PasswordSalt

MobilePIN

Email

LoweredEmail

PasswordQuestion

PasswordAnswer

IsApproved

IsLockedOut

CreateDate

LastLoginDate

LastPasswordChangedDate

LastLockoutDate

FailedPasswordAttemptCount

FailedPasswordAttemptWindowStart

FailedPasswordAnswerAttemptCount

FailedPasswordAnswerAttemptWindowStart

Comment

0 record(s) affected.

Leijun Jie - MSFT:

there are two stored procedures for retrieving user password: aspnet_Membership_GetPassword and aspnet_Membership_GetPassword. 

Leijun Jie- Greetings and Salutations!  When I read what you wrote above, I felt a feeling of hope with regard to this whole thing.

Yes-that there are quite a number of posts out there about this, and no, I have never found one with enough information to help a newbie.  T'here's a 26 part list and I understand most of it.  Someone else posted what looks to be a 10 page query to put into the query box.  I had my doubts about that.  Although these things are difficult to the new person, it always seems like once you know what to do, it isn't so bad (so I doubt 10 pages of query is the best answer).

With regards to GoDaddy, I've succeeded in getting into the database area, constructing a database (using a query) and constructing web.config files so that code prepared using VWD work on my computer (VWD 2005 EE) and on GoDaddy (without changing anything).  I have a tutorial (7 pages with lots of pictures) that walks a newbie through the steps of making a database on VWD, making it on GoDaddy, and making a page with a SqlDataSource, GridView and FormViews (for both Insert and Edit).  I'll help anyone with any of this.

But getting user authentication to work on GoDaddy--I'm not there yet.  GoDaddy even has a button to click so it writes the databases you need, but it feels like you bought a house and the real estate agent forgot to give you the keys.  Leijun Jie, with what you wrote above, I believe you must be the locksmith who can help us get into our homes in GoDaddyWorld!

May I respectfully join this conversation?  I'll help any way I can, if you can help us to make the keys.  And we will grant you the status of a god!  (mild humor comic relief thrown in because this whole thing can otherwise feel aggravating.)

 Best regards,

-Larry

You can not copy User and Membership information, it needs to be created from your application. I posted in another thread that you need to create a small application that you can install on your site somewhere that will allow you to create a new user, create new roles and assign the new users to their roles. At least a single admin login so you can then login as admin to that site and create new users from within your site.

You must also tripple check your Database information within you user CP that GoDaddy supplies, to make sure you ApplicationID is the same number in all your other tables, such as your Roles table. In you Application Table on GoDaddy check to see what you Application Name is and make sure you have it matched exactly in your web.config file.

Creating a membership based site locally using VS 2005 is really easy, moving it to a remote host takes a little more work and customization. Send me a PM if you are unable to figure this out from what I have said above, I have created a tool that works simular to the WAT tool within VS 2005 but can be deployed to a new site to set up the initial admin user and the roles you require.

I am having some GODADDY issues as well and would like to get a copy fo those instructions to successfully upload my web site to their server. If possible I would like to get a copy of that program that works with VS2005 as well. Thank you everyone for your assistance. marequi

I'm going to work on figuring out as much as I can from everything that you said.

I'm inferring from your post that perhaps you consider the tool you created to be--well, I am not sure how to word this--you made it, and you do not feel comfortable publishing it, possibly because the exhaustive extensive work it took to put it together given the dearth of available information.

If this is the case, I understand, and will not ask you otherwise.

But if not, and pointers, hints or clues that you can throw our way will be most happily received. 

Well, you have two of us now, and perhaps there will be more soon.

As to those two terms mentioned in the post that was marked as the answer--I'm reporting "no joy" on that front.  I put them into Google and almost nothing came back.  I haven't had a chance to go through the links listed, so maybe we'll get lucky there.

To the person who posted after me (sorry I don't have your name in front of me) who mentioned GoDaddy issues: are you referring specifically to making the user authentication function, or are you possibly referring to other issues such as making email work or getting into your database?  I can help you with email and database setup (not including user authentication).

-Larry

No I don't care about sharing the little application I created, I just would have to look at it again and make it a little more user friendly, since I built it I know exactly how to set it up.

I need to ask this though, did you use the User CP tools that GoDaddy has to initially create your aspnet data tables, such as aspnet_User, aspnet_Memberships and such?

Send me a PM with your email and I will send that tool to you at the start of the week with some minor documentation on how to deploy it and set up your roles and members, along with it is a working web.config file that you can feel free to use for your app, its pretty basic though so you may need to make alterations for it to work perfectly with your application.

quick question, what does CP stand for?

Control Panel