Last post Jun 16, 2007 10:29 AM by Navadia
May 25, 2007 08:29 PM|Navadia|LINK
I just started a site. I have the host I wanted to use and was give the option to make a Personal Website thou their control panel.
After I created the site, everything works but now that I am trying to use the login feature I cannot access the users. I can create a account
but I am unable to login until I approve the account. My problem is that the site is already online and I can copy the site to my personal PC
but I cannot access anything on it from home. I get an error message says that cannot remote connect to server. My question is can I
access the info from here? I have remote access to the database and site. Is this a common problem?
May 26, 2007 04:58 AM|jeremyh|LINK
Yes you do need to a pproved a user's first, One simple way is to open the table dbo.aspnet_Membership and edit the IsApproved from false to true.
You will also need to add the user to the administrators role.
So to add a role by sql query
EXEC aspnet_Roles_CreateRole '/', 'role'
"role" is the new role you want to add.
Then to add a user to a role
EXEC aspnet_UsersInRoles_AddUsersToRoles '/', 'username', 'role', 8
the 8 is timezone (If memory is correct)
Also take a look at
Hope this get you started.
May 26, 2007 11:28 PM|Navadia|LINK
What is the application that I need to be using?
I'm dreadfully sorry, but I am completely new to this stuff.
As to the site that you recommended to me. It's not much help because I would not be able to add it to the site. I can bearly edit the default.aspx page.
If you could walk me thou the steps, that would be great.
May 27, 2007 04:46 AM|jeremyh|LINK
Ok so to run the sql query's I told you about you need the host's online sql manager or if you are allowed to connection remotely to the sql server you can run the commands in visual web developer or sql manager express.
Tell me what host you are using and a url and I will see if I can give you more detailed step (post here,pm,email me your choice).
But take a look at these, they may help
Introduction to the Personal Web Site Starter Kit
Extending the Personal Web Site Starter Kit
Hope you find the information helpful.
May 27, 2007 06:55 AM|SalmonTraining|LINK
You've got as far as being able to register users on your Personal Starter Kit website - well done! This means that you've already got two roles (administrators and friends) added to your site - the Starter Kit adds these to the live database behind the
Now you need to use your host site's Control Panel to connect to your live database. Your host site will provide some kind of "Query Editor" which allows you to run commands (SQL) against the live database. You can run SQL commands which approve your users
and assign them to the roles of administrator or friend.
For those who are not familiar with SQL, Salmon Training has put together a SQL script which simplifies approval and assigning roles. It's available as a download (with instructions for use) at
May 27, 2007 12:14 PM|Navadia|LINK
OK I might sound like a total newbie but how do I run the script from my personal website to the host database? What I mean is how do you do it in step
by step instructions. I have SQL Server Management Studio Express and Microsoft Visual Studio 2005. How do I use these two programs to load the
database? I have access to them and can log in but I cannot figure out how to load my database to their server. I can get most of the other stuff done. And
there is no admin control in the control panel ofmy host. Just remote access to the database server.
I am using www.gate.com .
May 27, 2007 05:07 PM|jeremyh|LINK
Well maybe these steps will help you. Take a look here
Good luck, let me know how you get on.
May 28, 2007 02:52 PM|Chrisk1152|LINK
May 28, 2007 03:26 PM|Navadia|LINK
I'm getting an error with the link you sent me. Asks me to use a portal then sends me to the home help page.
OK I think I might have figued out how to use this thing. What I'm not sure of is which file to send to the database
to get a user into it. Do I have to start up the page on my personal PC then run the regsql thingy? I have figued
out how to load a file in the database.
Also I'm trying to use Mr. Wadsworth's template in a different folder of my site. I am getting a error there.
Line 16: <assemblies>
Line 17: <add assembly="System.Design, Version=184.108.40.206, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/></assemblies></compilation>
Line 18: <authentication mode="Forms">
Line 19: <forms loginUrl="Login.aspx" protection="Validation" timeout="300"/>
Line 20: </authentication>
It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS. (\\shared.hosting.local\nfs\cust\4\29\98\789924\web\ssg\web.config line 25)
It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS. (\\shared.hosting.local\nfs\cust\4\29\98\789924\web\ssg\web.config line 46)
It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS. (\\shared.hosting.local\nfs\cust\4\29\98\789924\web\ssg\web.config line 47)
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
How would I make the Directory into a IIS compliant one?
May 29, 2007 06:58 AM|jeremyh|LINK
Ok sorry about the gate.com link but if you go to their knowlegde
http://kb.gate.com and search for 71658 and choose "Specified Article ID Number"
May 29, 2007 11:16 PM|Navadia|LINK
OK I followed the instructions and I get a error saying that a error ocurred try again. Have not had any luck with getting it to work :(
is there another way to get a user approved as an admin?
May 29, 2007 11:18 PM|Navadia|LINK
Also I am having a problem with Mr. Wadsworths template. I am getting this error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
[HttpException (0x80004005): The file '/ssg/Master Pages/.master' does not exist.]
System.Web.UI.Util.CheckVirtualFileExists(VirtualPath virtualPath) +3374759
System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) +109
System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) +93
System.Web.Compilation.BuildManager.GetVPathBuildResult(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) +60
System.Web.UI.MasterPage.CreateMaster(TemplateControl owner, HttpContext context, VirtualPath masterPageFile, IDictionary contentTemplateCollection) +103
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +543
What would casue this error?
May 29, 2007 11:50 PM|jwadsworth|LINK
Run the following script on your database. First check the site_Settings table. If there is NOT a record in there, then remove the WHERE clause before running the script.
INSERT INTO site_Settings
(SiteName, SiteSlogan, SitePageTitle, MetaDescription, MetaKeywords, ThemeName, CopyrightCredits, EnableRegistration, EnableUserThemes, SMTP, RequiresAuthentication,
VALUES ('My New Website', 'My website slogan', 'My New Website', 'This is a website about family', 'family', 'Default', 'Copyright 2007', 1, 1,
'mail.comcast.net', 1, 'ausername', 'apassword')
WHERE SiteID = 1
May 30, 2007 12:09 AM|Navadia|LINK
that worked great. Now the only thing left is that I need to have a user added to the admin. How do I do that with it live?
May 30, 2007 03:39 AM|jeremyh|LINK
Well run this in a sql query window
EXEC aspnet_UsersInRoles_AddUsersToRoles '/', 'ausername', 'administrators', 8
and your user will be in the administrators role.
May 30, 2007 11:09 AM|Navadia|LINK
OK I've tried to do that. I used it from your earlier post. What I'm getting is is a message that says "1 row affected" but when I try to login I get the same message that normally pops in saying that
Your login attempt was not successful. Please try again. That is all I get. Is there another way to do this?
May 30, 2007 11:38 AM|jeremyh|LINK
Sure is you can manual put the data into the aspnet_UsersInRoles table.
So you need to open the table aspnet_Users in your sql tool and find the UserId for the user that you want to add to the role. (Copy it to notepad or some where)
and you then need to do the same for the RoleID in aspnet_Roles for the role you want and again copy some where.
Then when you have these two strings, add them into the aspnet_UsersInRoles table and save and your user will be in the admin role.
May 30, 2007 11:59 AM|Chrisk1152|LINK
May 30, 2007 12:17 PM|Navadia|LINK
all the tables dbo.application_Whatever does that matter? I can't get a one of them to work. I've tried more then one so far and I can add them to the
userinrole table but when I try to login nothing :( Do you have any suggestions? I'm will to try anything. This is starting to get annoying. You have any other suggestions?
May 30, 2007 12:25 PM|jeremyh|LINK
Its fine if the table have dbo. in front of the rest of the name.
Which one does not work?
I have sent you a pm asking for some more info.
May 31, 2007 01:15 AM|binupaulp|LINK
Jun 16, 2007 10:29 AM|Navadia|LINK
Woot the site works. Here take a look