Last post Jun 05, 2006 12:24 PM by jarice1978
May 25, 2006 12:27 AM|jarice1978|LINK
Okay I am sure that this has been posted a million times so please forgive me!
I have read several posts and everyone seems to have a different problem.
I am currently following Sue's directions from her website, hopefully she replies or someone else does that is familiar!
located here: http://edream.org/BlogArticle.aspx?RecordID=115
I have purchased web hosting with 3essentials.com. The package I purchased allows 1 SQL Server database.
Step 1: Done. Hosting ready. (however the database looks like it needs to be setup through their interface. Not sure how that is going to affect my efforts.)
Step 2: I have a couple questions here...
Is the script completely creating all the tables needed from scratch? Does this need to be run on a blank database? Personal?
I have SQLExpress as well as Visual Studio 2005 Professional(I am not sure what kind of database utilities this includes...Full version of SQL Server?)
I created a blank database called "Personal" in SQLExpress and ran Sue's script in it. It completed successfully.
Also, using SQLExpress I was able to attach to the Personal database located within the App_data folder in my personal site(locally). I tried to run the script against this database but there were a lot of errors. Mostly
about tables already being present...
This is as far as I got...
Anyway, I would really appreciate the help if someone could provide some direction...
Also, if someone has a better hosting company that would make this easier, please let me know.
J. Adam Rice
May 25, 2006 08:59 AM|suegooge|LINK
Welcome to the starter kit world!
My instruction is NOT made for local host. The application should be able to up and running out of box locally. So run the sql script against local sql express will mess up the tables already created.
Yes the script will create tables from scratch. Your remote sql server doesn't have these tables that's why you need it. You don't need to create a database name "personal.mdf" on remote server. Your host company should give you the sql server address, database
name, userid and password. the "Personal" appsettings is just the name to the desinated database.
Hope this helps.
May 26, 2006 11:17 AM|jarice1978|LINK
Thanks so much for replying Sue! I was thinking that this forum would notify me when someone replied but it didn't. So that is why I am just now getting back to you.
So to recap...
I have hosting with 3essentials.com. I have access to create 1 SQL Server database. I think I have created a database called "Personal" on the remote host already. From what you said, the datbase could be called anything,
just as long as I specify that in the code in the later steps in the instructions on your site. Is that right?
I have sent a support ticket to my host asking for the information you specified(sql server address, database name, userid and password)
Once I recieve the information back from my host, I should then be able to login, and run the SQL script against the empty "Personal" database. And to login and execute the script I can either use a SQL server client on
my machine, or the one you provided in the link:
And the other option would be to use a SQL utility that might be provided by my host...
Is that correct?
Again, thanks for your help! I am going to get this if it kills me:)
May 30, 2006 10:01 AM|suegooge|LINK
Yes, database name can be anything. The .net code pick up the connection string in web.config file.
How's everything going now?
May 30, 2006 10:37 AM|jarice1978|LINK
Well I didn't get much done over the holiday weekend...
However, my hosting company replied with the information I needed. In order to set up a remote connection to the database, I need
MS-SQL 2000 Enterprise Manager. They said that they do not support SQL Server 2005. In order for the remote connection to work I needed to download and configure Tunnelier for SSH Tunnel.
I have downloaded and confugured the Tunnelier. From what I gather it is basically a service that runs and encrypts the information you are sending back and forth to my hosting company's servers. However, from where I
am at right now(work), I can not connect. I will need to wait until I get home tonight and try again.
Do you know where I can get a copy of
MS-SQL 2000 Enterprise Manager?
I think my hosting company also has an interface for accessing the database, but in order for it to work they told me I need to tranfer my domain name. I am still evaluating this host, so I was a little leary of tranferring
my domain name there...I was thinking I would be able to use there web interface regardless of having my domain name tranferred but I guess not...
So at this point I need to:
1.) obtain a copy of MS-SQL Enterprise Manager and install
2.) attempt to connect to hosts database server with the Enterprise Manager while Bitvise Tunnelier is running. (I will need to do this at home because I am currently behind a firewall)
3) If the above steps are successful, I will attempt to run the scripts against the database...
Does this all make sense?
May 30, 2006 11:30 PM|jarice1978|LINK
Okay. I was able to connect and run the "personal-add.sql" script on the empty database at my host.
Step 3: Done. (I think!)
Step 4: I only commented out
<!-- <roleManager enabled="true"/>
because the other line was not in my .config file. Should it have been?
I inserted all the other code you specified. So now my config file looks like this:
System.Web, Version=22.214.171.124, Culture=neutral,
description="SiteMap provider which reads in .sitemap XML files."
type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
I attempted to run the file you specified. It started a wizard. I then went to select the database name from the list box and it failed with the following error:
"Failed to query a list of database names from the SQL Server. An error occurred while establishing a onnection to the server. When connecting to SQL Server 2005, ths failure may be caused by the fact that under the default settings SQL Server does not
allow remote connections.(provider:TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)"
This doesn't really make sense to me. I was able to connect earlier and run the personal-add.sql script...
May 31, 2006 12:10 AM|jarice1978|LINK
Just another quick note...
I found this in my hosting sites knowledge base:
"3Essentials hosting plans currently do not support the ASP.Net 2.0 Role Manager function due to lack of integration support from the
Plesk Control Panel"
Is this going to be a problem???
May 31, 2006 11:11 AM|jarice1978|LINK
Okay, this really stinks!
Here is a reply from my hosting company...
3Essentials hosting plans currently do not support the ASP.Net 2.0 Role Manager function due to lack of integration support from the Plesk Control Panel.I am afraid we are unbale to assist you in this matter any further.
Please feel free to contact us for further assistance.
Well they are unable to assist me any further in this matter, but I can contact them if I need any further assistance.??? Thanks!
Anyone reading this...WHAT QUALITY HOSTS ARE YOU USING THAT ALLOW ALL THE FUNCTIONALITY CONATINED IN THE STARTER KIT?
3essentials hosting was my second hosting account I have tried this with. M6.net was the first....
May 31, 2006 11:23 AM|suegooge|LINK
Sorry for your trouble. Please don't try GoDaddy or any other host doesn't support remote connection on sql server. In this case you basically CAN'T backup your own database. I don't know how many people feel comfortable with that. Of course there is a
way to work around, but it's not that simple and easy. I need to add some guide choosing host company in my tutorial.
I use boundgrid.com and webhost4life.com. Have been happy so far - knock on the wood!
May 31, 2006 09:39 PM|jarice1978|LINK
BINGO! That's it Sue!
I changed hosts to boundgrid.com and I am up and running! Thanks for the suggesstion.
So far things seem like they are working, except that I am not sure if I am set up as the Administrator. I am thinking that I should be able to add myself as the Admin in the database manually right?
let me know if you have any suggestions...meanwhile I will try to figure it out...
May 31, 2006 11:16 PM|jarice1978|LINK
Okay, ibasically figured out that there are no roles set up in my remote server database. So, what is the best way to do this? I know I can can run the ASP . Net Configuration manager on my local copy, but is there some way to manage roles on the remote
host, or even add them???
Jun 01, 2006 05:21 PM|jarice1978|LINK
So I still have the same problem.
I can run the ASP .Net Configuration Manager on the remote site from my local machine, however I still can not figure out how to create the roles automatically. When I did this on my local database, the 2 roles are created the first time you run the application,
however that doesn't seem to be the case when it is on a remote site...
so as of now, my aspnet_Roles table is empty....
Can anyone help me?
Jun 03, 2006 09:57 PM|whighfield|LINK
If you want to create the roles the dirty way create a simple aspx page and put this in the Page_Load event
If (Roles.RoleExists("Administrators") = False) Then
If (Roles.RoleExists("Friends") = False) Then
Then upload the page and or the code file to your remote site and then call the page from a browser.
Jun 05, 2006 12:24 PM|jarice1978|LINK
That makes sense. I will try that tonight.