Try this from scratch:

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.

1. Select
2. Check DSN (optional?)
3. Enter UserName (this will become the database name NOT your hosting login)
4. Enter Password (again, database password NOT hosting password)
5. Check "Install Schema Features"
6. 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)
7. Once setup finishes, Click Pencil icon under actions > print this page.
8. Click Computer icon under actions > record the SQL Connection (.NET) strings
9. Click Open Manager
10. Click Connection > Enter the Username and Password from 6 above.
11. Once connected, expand Tools menu > Click Query Analyzer
12. Cut & Paste all text from club-add.sql into the Query Analyzer window
13. Click Submit (you should see many "command(s) completed successfully" below)
14. Go back to VWD and edit default.aspx
15. Go to Edit > Find & Replace > Quick Replace
16. Find dbo. (NOT Dbo. big difference)
17. Replace with <blank> (nothing, nada, zip, zero)
18. Look in: Current Document
19. Click Replace All (should be 12 or more) > Save default.aspx
20. Repeat steps 16 & 17 for:
21. Events_Edit.aspx
22. Events_View.aspx
23. Open web.config
24. 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"/>

25. 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"/>

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

27. Save!!!

28. 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")

29. Click Website > Copy Web Site > Connect

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

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

32. 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!!!)

33. Log back into Query Analyzer

34. Input

    1. SELECT RoleId FROM aspnet_Roles WHERE RoleName="Administrators"

35. Copy bracketed response into a text document and include the brackets