hackneys:

Ok.

1. This posting will help you with that; http://www.wwwcoder.com/main/parentid/258/site/5221/68/default.aspx

Thanks... I'll check that out.

hackneys:

2.  What happens is they are ask a secret question that they had to make up when they registered, if they answer it correctly they are sent a temporary system made password.  They then can log in and they will have to change there password to something they want.

OK.  I kind of assummed that, but was curious.  I'm sure I'll have some of these boneheads that will forget their secret answer, but they'll just have to create a new user account. :-)

hackneys:

3.  The whole site does not need to be done.  You cannot access the ASP.net configuration on GoDaddy's servers.  For user administration you will have to use MaineOne's admin tools listed earlier in this string (unless you write your own).  Everything else can be changed in the web.config file.  What I do is have two web.config files.  One on GoDaddy's servers setup the way the db string need to be setup there, and one on my local machine.  That way I can develop on my laptop, and once I know it is working, I build the site, and push the pages I changed up to the GoDaddy site.  I never overwrite the web.config file on GoDaddy's server unless I know I made a change.

Ahhh... that's good info.  Never thought about having a seperate web.config file... makes total sense.  Another reason I enjoy this forum... lots of good info here.

Thanks for your help.

BoosterMan - MAJOR kudos to you sir for creating such a thorough walkthrough!  It took my slow dumb self a while to walk through it step by step, but I was SHOCKED to see that it actually worked correctly the first time!!  Well...except for the user name/role stuff (not sure why that didn't work

hackneys - Thank you as well for the suggestions posted above, as well as the link to aspSKsolutions!

My next question involves maintaining this site.  Is there any way to set up VWD to work on a local copy when I want to just make a quick edit?  Or would I need to go through a good chunk of the original steps again and basically undo a lot of stuff?  I went through the steps to extend the kit as posted on http://msdn.microsoft.com/asp.net/default.aspx?pull=/library/en-us/dnaspp/html/extendclubwebsitesk.asp, and I'm now having problems w/ the Docs stuff.  I don't expect to have to modify the DB tables, just the syntax of the page.

I am having the same issue.  Here is what I get when I attempt to do the INSERT INTO command:

Now, my code may be wrong, and feel free to correct me, PLEASE.  But, I've tried every combination I can think of, and am having no luck.

Furthermore, I downloaded the utility from MaineOne, and to be honest, it was very confusing to me on how to get that utility working.  Is there some way around this that I can just add the necessary records to the DB?  I only  have 3 users to give Admin rights too.

Thanks.

Furthermore, I worked my way in to where I could manually put in the RoleId and the UserId, and I got this response:

Thanks.

Here is the correct syntax for the issue above:

INSERT INTO aspnet_UsersInRoles (RoleId, UserId) VALUES ('BBEA9AD2-47D5-4187-B6A8-9883E699D5D3', '0A4E9A78-24AF-4CF3-93C7-1F52FC46AFA1')

If you copy and paste that, this should clear up your problem

This is a result of a typo:  Here is the correct syntax:

SELECT RoleId FROM aspnet_Roles WHERE RoleName = 'Administrators'

Hope this help,

Steve

First, Thank you for the excellent post, great job.  It helped me tremendously.  Thank you again.  Below I have modified your script to help us "noobs" out and fix a couple of typos

   1. Create your site locally.  Include AT LEAST 1 local admin account.
   2. Run site using CTRL-F5.
   3. Log into your GoDaddy hosting account and open the control panel.
   4. Click on ASP.Net runtime and select 2.0
   5. Click Databases > SQL Server > Create New Database.
   6. Select
         1. Check DSN (optional?)
         2. Enter UserName (this will become the database name NOT your hosting login)
         3. Enter Password (again, database password NOT hosting password)
         4. Check "Install Schema Features"
   7. Click Continue > Create Database (it WILL take some time for the database to create itself, you can refresh by clicking the SQL button in the left menu)
   8. Once setup finishes, Click Pencil icon under actions > print this page.
   9. Click Computer icon under actions > record the SQL Connection (.NET) strings
  10. Click Open Manager
  11. Click Connection > Enter the Username and Password from 6 above.
  12. Once connected, expand Tools menu > Click Query Analyzer
  13. Cut & Paste all text from club-add.sql into the Query Analyzer window

  14. Click Submit (you should see many "command(s) completed successfully" below)

  15. Go back to VWD and edit default.aspx
  16. Go to Edit > Find & Replace > Quick Replace
         1. Find dbo. (NOT Dbo. big difference)
         2. Replace with <blank> (nothing, nada, zip, zero)
         3. Look in: Current Document
  17. Click Replace All (should be 12 or more) > Save default.aspx
  18. Repeat steps 16 & 17 for:
         1. Events_Edit.aspx
         2. Events_View.aspx
  19. Open web.config
         1. Replace original text
               1.

                  <add name="ClubSiteDB" connectionString="Data Source=.\SQLExpress;

                        Integrated Security=true;

                        AttachDBFileName=|DataDirectory|Club.mdf;

                        User Instance=True" providerName="System.Data.SqlClient"/>
         2.

            With new text
               1.

                  <add name="ClubSiteDB" providerName="System.Data.SqlClient"

                        connectionString="server=whsql-v04.prod.mesa1.secureserver.net;

                        database=DB_12345;

                        uid=myusername;

                        pwd=mypassword"/>

                  <remove name="LocalSqlServer"/>

                  <add name="LocalSqlServer" providerName="System.Data.SqlClient"

                        connectionString="server=whsql-v04.prod.mesa1.secureserver.net;

                        database=DB_12345;

                        uid=myusername;

                        pwd=mypassword"/>
  20.

      Change <customErrors mode="Off" /> (optional)
  21.

      Save!!!
  22.

      Run CTRL-F5 again.  (it will bring up a window with a server error, what you want is to look in the lower left corner of the VWD window for "Build Successful")
  23.

      Click Website > Copy Web Site > Connect
  24.

      Input your hosting username and password (NOT you database uid and pwd)
  25.

      Highlight all files from the left side and click right arrow to transfer.
  26.

   *   Go to your public website and create an account for each admin you created on your local database.  (make sure the usernames and passwords are the same!!!)
  27.

      Log back into Query Analyzer
  28. To Grant Administrator Privileges to an ASP.NET 2.0 User Account

   1. Log in to your Account Manager.
   2. Under the Hosting & Email section, select Hosting Account List.
   3. Next to the hosting account you want to modify, click Open.
   4. Under the Databases section of the Hosting Manager, click the SQL Server icon.
   5. Next to the name of your SQL Server database, click Open Manager. The SQL Server Web Admin tool displays.
   6. In the tree on the left, expand the Connection folder and select Connection.
   7. Enter the User Name and Password for your database. You created your user name and password when you set up your SQL server database.
   8. Expand the Tools folder on the left and select Query Analyser.
   9. Copy the following T-SQL statement into the Query Analyser window:

      SELECT RoleId FROM aspnet_Roles WHERE RoleName = 'Administrators'

      Click Submit and save the return value for use in step 11. Click Reset.
  10. Copy the following T-SQL statement into the Query Analyser window:

      SELECT UserId FROM aspnet_Users WHERE UserName="username"

      Replace <username> with the user name of the account to which administrator privileges will be granted. Retain the single quotation marks around this case-sensitive value. Click Submit and save the return value for use in step 11. Click Reset.
  11. Copy the following T-SQL statement into the Query Analyser window:

      INSERT INTO aspnet_UsersInRoles (RoleId, UserId) VALUES ('<roleID>', '<userID>')
EXAMPLE: INSERT INTO aspnet_UsersInRoles (RoleId, UserId) VALUES ('7321ED9B-64FB-47C2-B139-2AF810678D59', 'E421C366-2905-40FC-8543-0AA618FEE17E')

      Replace <roleID> with the return value from step 9. Replace <userID> with the return value from step 10. Retain the single quotation marks around these values. Click Submit.

Thanks again to BoosterMan, and all those who made this walkthrough possible.  Great Job and keep up the good work

Thank you, thank you, thank you.  Yes, I'm a noob, and was typing the wrong syntax.  Thanks so much for the clarification... that seemed to resolve my issue.

Thanks again.

Boosterman;

You have truly created a good step by step guide.  Unforntualy, I am stuck  I have completed up to step 26.  When I try to go to my website (http://www.africa4jesus.org/club/)  I get an error message. 

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0103: The name 'SharedRoutines' does not exist in the current context

Source Error:

Line 136:                            </h3>
Line 137:                            <p>
Line 138:                                <asp:Label ID="Label2" runat="server" Text='<%# SharedRoutines.truncate((string)Eval("description")) %>' />
Line 139:                                <a href='<%# "News_View.aspx?Articleid=" + Convert.ToString(Eval("ID")) %>'>read more &raquo;</a>
Line 140:                            </p>

I hope you can help.  I don't understand why "The name 'SharedRoutines' does not exist in the current context".

I have follow all the instructions step by step but when I go to see the site on step 26,

I got the error page check here: http://www.kovnat.com

My host company is http://www.UnicoDomian.com

and same rules applies, because this one is one of the many reseller's sites that is under the reseller plan

that offer the company mention on step 3. I just find out.

Kovnat.com

kovnat:

I have follow all the instructions step by step but when I go to see the site on step 26,

I got the error page check here: http://www.kovnat.com

My host company is http://www.UnicoDomian.com

and same rules applies, because this one is one of the many reseller's sites that is under the reseller plan

that offer the company mention on step 3. I just find out.

Please email me with the answers at Mailto: kovnat@kovnat.com

Thank you for your help in advanced!....

Kovnat.com

hackneys:

Ok, to answer my own question one, to solve the problem with email settings at GoDaddy, ad the following to the web.config file;

  <system.net>
    <defaultProxy>
      <proxy usesystemdefault="False"      proxyaddress="http://wc-v01.inet.mesa1.gdg:3128"      bypassonlocal="False" />
    </defaultProxy>
  </system.net>
 
  <system.net>
      <mailSettings>
        <smtp deliveryMethod="network" from="youemail@yourhost.com">
          <network
            host="relay-hosting.secureserver.net"
            port="25"
            defaultCredentials="true"
        />
        </smtp>
      </mailSettings>
    </system.net>

Enjoy...

Shane L. Hackney

Thanks Shane!  I spent all night trying to figure this out using my godaddy host!  Works great!!