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.
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:
Error -2147217900
Syntax error or access violation
INSERT INTO aspnet_UserInRoles (RoleId, UserId) Values ({0A4E9A78-24AF-4CF3-93C7-1F52FC46AFA1}, {BBEA9AD2-47D5-4187-B6A8-9883E699D5D3})
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.
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.
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.
Your not alone, so am I. I was going around in circles, the walkthrough was really well done, until I hit that spot. So thankfully to Google and a couple of other websites I was able to piece together what was wrong.
jeepinchad
Member
45 Points
9 Posts
Re: GoDaddy Installation Walkthrough
Apr 13, 2006 05:41 PM|LINK
Thanks... I'll check that out.
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. :-)
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.
MysteryMan
Member
5 Points
1 Post
Re: GoDaddy Installation Walkthrough
Apr 16, 2006 03:46 AM|LINK
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.
jeepinchad
Member
45 Points
9 Posts
Re: GoDaddy Installation Walkthrough
Apr 26, 2006 07:59 PM|LINK
I am having the same issue. Here is what I get when I attempt to do the INSERT INTO command:
Syntax error or access violation
INSERT INTO aspnet_UserInRoles (RoleId, UserId) Values ({0A4E9A78-24AF-4CF3-93C7-1F52FC46AFA1}, {BBEA9AD2-47D5-4187-B6A8-9883E699D5D3})
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.
jeepinchad
Member
45 Points
9 Posts
Re: GoDaddy Installation Walkthrough
Apr 26, 2006 08:22 PM|LINK
Furthermore, I worked my way in to where I could manually put in the RoleId and the UserId, and I got this response:
Syntax error or access violation
INSERT INTO [DB_57846].[dbo].[aspnet_UsersInRoles] ([UserId], [RoleId]) VALUES ({BBEA9AD2-47D5-4187-B6A8-9883E699D5D3}, {0A4E9A78-24AF-4CF3-93C7-1F52FC46AFA1})
Thanks.
MaineOne
Contributor
2087 Points
469 Posts
Re: GoDaddy Installation Walkthrough
Apr 26, 2006 09:02 PM|LINK
NY_Steve
Member
30 Points
6 Posts
Re: GoDaddy Installation Walkthrough
Apr 27, 2006 03:19 AM|LINK
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
NY_Steve
Member
30 Points
6 Posts
Re: GoDaddy Installation Walkthrough
Apr 27, 2006 03:20 AM|LINK
This is a result of a typo: Here is the correct syntax:
SELECT RoleId FROM aspnet_Roles WHERE RoleName = 'Administrators'
Hope this help,
Steve
NY_Steve
Member
30 Points
6 Posts
Re: GoDaddy Installation Walkthrough
Apr 27, 2006 03:33 AM|LINK
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
jeepinchad
Member
45 Points
9 Posts
Re: GoDaddy Installation Walkthrough
Apr 27, 2006 01:47 PM|LINK
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.
NY_Steve
Member
30 Points
6 Posts
Re: GoDaddy Installation Walkthrough
Apr 27, 2006 10:44 PM|LINK