Manually Add Admin Access Account

Topics: Developer Discussion, Help, Request
May 14, 2007 at 6:54 PM
Ran the sql schema script, I can't login,
I ran the data sql script (which I would rather not do) and it generates errors.

Anyone know an easy way to manually add an Admin user account so I can manage my website?


Thanks
Hotaling
Coordinator
May 14, 2007 at 7:49 PM
ASP.NET Configuration tool.
May 14, 2007 at 8:44 PM
Thanks,

Does this require Front page Server Extentions?

When I connect to the remote server via FTP I do not see the ASP.NET Configuration Tool option on the website menu.


May 15, 2007 at 10:15 PM
asp.net config tool is only available on your local machine I believe. What host are you using? There are some directions on the asp,net forums in the csk and psk forums that address a go daddy walk though, which may be similar for your host. I believe it is step 26. basically you select the admin account from your local (dev) system and insert into your remote (production) system. THis keeps the credentials for development and production the same.

May 16, 2007 at 2:14 AM
I use go daddy,

let me know if you come accross insert directions.
I am looking for them, as it stands I can create a user account, but I dont have admin access.


May 16, 2007 at 2:47 AM
Here you go:

Create your site locally. Include AT LEAST 1 local admin account.
Run site using CTRL-F5.
Log into your GoDaddy hosting account and open the control panel.
Click on ASP.Net runtime and select 2.0
Click Databases > SQL Server > Create New Database.
Select
Check DSN (optional?)
Enter UserName (this will become the database name NOT your hosting login)
Enter Password (again, database password NOT hosting password)
Check "Install Schema Features"
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)
Once setup finishes, Click Pencil icon under actions > print this page.
Click Computer icon under actions > record the SQL Connection (.NET) strings
Click Open Manager
Click Connection > Enter the Username and Password from 6 above.
Once connected, expand Tools menu > Click Query Analyzer
Cut & Paste all text from club-add.sql into the Query Analyzer window
Click Submit (you should see many "command(s) completed successfully" below)
Go back to VWD and edit default.aspx
Go to Edit > Find & Replace > Quick Replace
Find dbo. (NOT Dbo. big difference)
Replace with <blank> (nothing, nada, zip, zero)
Look in: Current Document
Click Replace All (should be 12 or more) > Save default.aspx
Repeat steps 16 & 17 for:
Events_Edit.aspx
Events_View.aspx
Open web.config
Replace original text
<add name="ClubSiteDB" connectionString="Data Source=.\SQLExpress;

Integrated Security=true;

AttachDBFileName=|DataDirectory|Club.mdf;

User Instance=True" providerName="System.Data.SqlClient"/>

With new text

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

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

Save!!!

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

Click Website > Copy Web Site > Connect

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

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

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

Log back into Query Analyzer

Input

SELECT RoleId FROM aspnet_Roles WHERE RoleName="Administrators"

Copy bracketed response into a text document and include the brackets

Reset QA and Input

SELECT UserId FROM aspnet_Users WHERE UserName="username"

Copy each bracketed response to your text document.

Reset QA again and Input

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

Repeat 28-32 for each admin account.

Welcome to your club site on GoDaddy!

Thanks to MaineOne and btech_rohit for insight into this problem!

May 16, 2007 at 5:15 AM

SELECT RoleId FROM aspnet_Roles WHERE RoleName="Administrators"

Error -2147217900
Invalid column name 'Administrators'.

May 16, 2007 at 4:52 PM
Did you try the singular case?
May 17, 2007 at 3:19 AM
Where is the "club-add.sql" file? I downloaded the Data.sql and Schema.sql

nonprofit
May 17, 2007 at 5:02 AM
club-add.sql was from version 1.0. (its not used in version 2.0)

Just run the schema.sql to start clean with out test data.


May 17, 2007 at 11:11 AM
{quote}
hotaling wrote:
club-add.sql was from version 1.0. (its not used in version 2.0)

Just run the schema.sql to start clean with out test data.

How is the schema.sql run (within Query Analzyer?) Could you give simple instructions for this newbie? Appreciate your patience
May 17, 2007 at 3:11 PM
Yes with query analzyer!

open the .sql file with visual web developer or sql managment studio copy and paste it in your sql web server query analyzer.

You may be able to use sql managment studio to connect to your sql web server directly and open/run the query. (i.e. when sql managment studio starts in the connect to server name enter your sql web server ip address) most likley you will change to sql authentication and enter you sql ID and password).

Hope this helps.