Dear Forumers,
Do any of you know a good tutorial to get a personal web site running on godaddy.com ?
I haven't done it , but I was looking through the help last night at godaddy- I did see that they had a few answers about running the personal website. You have to set up your SQL database and configure a login. If you go to godaddy.com - Login -My Account - then go to Help. search for both personal website and asp.net 2.0, you should find what you're looking for.I also have a question about it. I've taken a look at the help and tried to follow their instructions, but I'm running into problems. They say, in order to activate the account, you need to:
Expand the Tools folder on the left and select Query Analyser.
Copy the following T-SQL statement into the Query Analyser window:
SELECT UserId FROM aspnet_Users WHERE UserName = ''
Replace with the user name of the desired account. Retain the single quotation marks around this case-sensitive value. Click Submit and save the return value for use in step 10. Click Reset.
Copy the following T-SQL statement into the Query Analyser window:
UPDATE aspnet_Membership SET IsApproved = 1 WHERE UserId = ''
Replace with the return value from step 9. Retain the single quotation marks around this value. Click Submit.
My problems is that when I cut 'n paste and replace the username in the first step, I don't get any return value. The only thing that displays is "0 records affected."
Could you help me?
Once again, I haven't done it - but I might be able to help
First things first - you need to enable .Net 2.0 schema in the database.....
then you need to run that 'personal-add.sql '
http://help.godaddy.com/article.php?article_id=695&topic_id=216&prog_id=GoDaddy&isc=
this (I'm guessing) should create a user in the aspnet_user table - either run that other sql
"SELECT UserId FROM aspnet_Users WHERE UserName = '" or just browse the table and look up the user id assigned ( once again - i am assuming the personal-add.sql has the username )
I haven't tried it out yet, but I just wanted to thank you for taking your time to help me.
Ok i got my website runninghttp://estheticorp.com/ but i dont know how to create administrative accounts or modify my database. I see tutorials on MSDN but they are for local web hosts using IIS.
My website is stored on GoDaddy so the config options are not available. Can some guru please step in and school us?
dc303:
I also have a question about it. I've taken a look at the help and tried to follow their instructions, but I'm running into problems. They say, in order to activate the account, you need to: Expand the Tools folder on the left and select Query Analyser. Copy the following T-SQL statement into the Query Analyser window: SELECT UserId FROM aspnet_Users WHERE UserName = '' Replace with the user name of the desired account. Retain the single quotation marks around this case-sensitive value. Click Submit and save the return value for use in step 10. Click Reset. Copy the following T-SQL statement into the Query Analyser window: UPDATE aspnet_Membership SET IsApproved = 1 WHERE UserId = '' Replace with the return value from step 9. Retain the single quotation marks around this value. Click Submit. My problems is that when I cut 'n paste and replace the username in the first step, I don't get any return value. The only thing that displays is "0 records affected." Could you help me?
this i can help with.. make sure the option box checked "show return value" is on. If that is not the name look more carefully i may have forgotten the name but it is on the windows of the query analyzer tool on the top.
0 comments:
Post a Comment