Thanks BoosterMan and all others that contributed to this thread.  I was tearing my hair out trying to get my site "live".  I picked GoDaddy based on this thread.  Previously I was using hostmysite.com with no luck.  I'm sure that hoster would work... but I couldn't figure it out.  The instructions provided by BoosterMan will work for the Personal Web Site starter kit although they were originally written for the club site.

Really, GoDaddy should be paying you a fee and posting this on their website! 

Thanks again,

Dave

When I submit select * from aspnet_roles in the godaddy query analyzer I don't get back any rows.  I'm trying to publish my own site not the club site.  Do I have to create the Administrator role and then follow the rest of the steps?  I've created an account through my site but I'm not sure what to do next since I'm not seeing any roles in my aspnet_roles table.  Any ideas?

Thanks

Amit




 

I'm stuck at step number 28. When I copy and paste:

 into the Query Analyser, I get the following error:

Error -2147217900
	Error -2147217900
	Invalid column name 'Administrators'. SELECT RoleId FROM aspnet_Roles WHERE RoleName="Administrators"  What exactly did I do wrong?

I've used the Walkthrough myself and everything worked migically. One little correction at step 28--Administrators should be sourrounded by single quotes not double quotes. Other than that...hats down BoosterMan.

post scriptum: would I be able to publish the Personal site starter kit using the same instructions? I am mostly worried about the find an replace part.

I just followed all the steps to get my website up and running.  No problems there.  The website it running fine.  I cannot login though.  I created admin locally and then and then went to public website and created an account, and then followed the steps to grant admin privileges, but I still cannot login.  It tells me loging failed.  Any ideas?

Also, I have a page that I will be updated frequently (daily) and I will need to publish only this page.  Is there a way to do this?  It seems that when I open Copy Website and connect everything is listed as new on source and remote with question marks next to them.  It goes through the process of uploading but it never seems to finish.  The progress bars disappear but it says it is still uploading and I cannot click anything, and I have to close it out and it doesn't seem like anything is being updated.  Any ideas what is wrong here.  I am new to this and trying to get this working!!

I am encountering the same problem - Can I ask you what you did to fix it? What typo did you fixed?

Thank you,

dpr

Well first, thanks for this post.  I know I'm late to the game here, but I just set my site up with GoDaddy, and this was a life saver.

I would highly suggest using either Dreamweaver or another FTP like Cute to upload your files to GoDaddy.  I originally setup my site as a FTP connection and every time you edit the page, switch views, anything it reloads the whole site. To the posters above, If you follow the steps on the first page from with in the DB manager, you can create your admin accounts, but to log in you need to be approved.  In the asp.net_memberships table, there's a bit field called IsApproved, it must be checked to login obviously.

I am also relatively new to using .NET apps, can someone with experience tell me.  How do you approve users without going into the DB?  Or is that something we would have to create, ie. another admin page like the photos page?
 

dirt:

Well first, thanks for this post.  I know I'm late to the game here, but I just set my site up with GoDaddy, and this was a life saver.

I would highly suggest using either Dreamweaver or another FTP like Cute to upload your files to GoDaddy.  I originally setup my site as a FTP connection and every time you edit the page, switch views, anything it reloads the whole site. To the posters above, If you follow the steps on the first page from with in the DB manager, you can create your admin accounts, but to log in you need to be approved.  In the asp.net_memberships table, there's a bit field called IsApproved, it must be checked to login obviously.

I am also relatively new to using .NET apps, can someone with experience tell me.  How do you approve users without going into the DB?  Or is that something we would have to create, ie. another admin page like the photos page?

A complete user admin package for the club web site has already been created.  Unfortunately, it's not available at the moment because the author is working on a new version.  The author's site is www.aspsksolutions.com.  I think that the new version will be released soon.

New version will be available as soon as i finish the setup instructions.  The one issue I still need to address is the sql scripts.  It seems the ones I create using my SQL2000 do not work on every query analizer.  I probably will write up how to manually create tables and stored procedures for those who have difficulty's. Time is the biggest factor, but I hope to have the upgrade version released by tommorrow and the New User version by Monday.  The new version will be free, as my site is now self supporting, thanks to all of you.

bridgetgregory:

Are you saying that you have to approve everyone that creates an account or is that just for administrators?  Thank you.

 The above mentioned package allows you, as site administrator, to configure how new accounts are approved.  Options are automatic approval, email verification, or administrator approval.

bridgetgregory:

Are you saying that you have to approve everyone that creates an account or is that just for administrators?  Thank you.

 The above mentioned package allows you, as site administrator, to configure how new accounts are approved.  Options are automatic approval, email verification, or administrator approval.

Okay so I'm kind of new at all of this. I followed all of the steps and got my site up and connected to the DB (thanks to everyone by the way). The problem is that I removed all of the member registration parts of the site b/c I only want one admin. I tried manually inserting an admin into Go Daddy's tables but was unsuccessful. Can anyone help me created an Admin role manually????

 Thanks!  

I'm sure the last thing everyone needs is another dumb question. But.

I'm running SQL Server Express 05 and have already built a simple database. After subscribing to GoDaddy (Windows this time, I've had PHP), I found this site useful.

 Now, there are constant references to this "personal-add.sql" on the GoDaddy help site. But My SQL Server doesn't generate any such files. I've tried to use SQL Server Express to Script the database as a new file, then send that text thru the godaddy query, but no luck!!