My Godday control panel is listed below.  I can not work out how to upload my pictures or logon as the Adminastrator?

aspnet_Applications	dbo	2/18/2007 3:40:10 AM	PRIMARY	1
aspnet_Membership	dbo	2/18/2007 3:40:11 AM	PRIMARY	1
aspnet_Paths	dbo	2/18/2007 3:40:18 AM	PRIMARY	0
aspnet_PersonalizationAllUsers	dbo	2/18/2007 3:40:18 AM	PRIMARY	0
aspnet_PersonalizationPerUser	dbo	2/18/2007 3:40:18 AM	PRIMARY	0
aspnet_Profile	dbo	2/18/2007 3:40:15 AM	PRIMARY	0
aspnet_Roles	dbo	2/18/2007 3:40:16 AM	PRIMARY	2
aspnet_SchemaVersions	dbo	2/18/2007 3:40:10 AM	PRIMARY	6
aspnet_Users	dbo	2/18/2007 3:40:10 AM	PRIMARY	2
aspnet_UsersInRoles	dbo	2/18/2007 3:40:16 AM	PRIMARY	1
aspnet_WebEvent_Events	dbo	2/18/2007 3:40:19 AM	PRIMARY	0
Albums	jtboyle40	2/18/2007 6:00:20 AM	PRIMARY	0
Photos	jtboyle40	2/18/2007 6:00:20 AM	PRIMARY	0

"How did you get all the aspnet tables on your site?"

This drove me up the wall.  You need to create the folder that holds aspnet file on the Godaddy control panel (Not just uploading on FTP) as the directory need write access and again this is done throught the Godaddy Control Panel only.

When you have the correct pemissions you can progress.

I went through this from Booster Man

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

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

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

32. Save!!!

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

34. Click Website > Copy Web Site > Connect

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

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

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

38. Log back into Query Analyzer

39. Input

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

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

1. Reset QA and Input

2. SELECT UserId FROM aspnet_Users WHERE UserName="username"

3. Copy each bracketed response to your text document.

4. Reset QA again and Input

   1. INSERT INTO aspnet_UsersInRoles (RoleId, UserID) VALUES ('copied text from 29', 'copied text from 31')

5. Repeat 28-32 for each admin account.

6. Welcome to your club site on GoDaddy!

    

Also add this into the into Query Analyzer to add roles and the it all works.

/*

Please change the YOUR_USERNAME_HERE text to your username you entered in when you registered to your PWSK.

*/

DECLARE

@userID uniqueidentifier,

@roleID uniqueidentifier,

@userName nvarchar(256)

SET @userName = 'YOUR_USERNAME_HERE'

SET @userID = (SELECT TOP 1 UserId FROM aspnet_Users WHERE UserName = @userName)

UPDATE aspnet_Membership SET IsApproved = 1 WHERE UserId = @userID

SET @roleID = (SELECT RoleId FROM aspnet_Roles WHERE RoleName = 'Administrators')

INSERT INTO aspnet_UsersInRoles (RoleId, UserId) VALUES (@roleID, @userID)