have you guys installed .NET 2.0 framework? you should have this file in your computer unless you didn't install it in on the default folder. search aspnet_regsql.exe in your computer see if you can find it and make sure it is the right version. Without .net
2.0 framework installed you won't be able to run personal web site in your local ocmputer.
Hi Adam, I just stumbled across this thread while on my way to somewhere else.I have not read it carefully and am not nearly as attractive as Sue, but I just worked my way through similar problems with PWS and this may help you anyway.Here are a couple of things to look at:
1) It's not good if you're hosted shared server (dedicated serves are more expensive).This means that you share address space with other SQL Server and SQL Express users.You can't use the names "aspnertdb" or "Personal" if someone else has beaten you to them.You ISV can rename your DBs to something else, but this is a pain it you want to do a lot of design changes and upload the results.
2) You may need to set permissions (probably Network Service) to Read/Write/Modify/Delete on the App_Data folder so the DBs can attach the scripts and create the structure including the log file.
I decided to convert over to an Access DB to make frequent redesign and upload easier. Buzz me for more info if you want to go this route.
You're right about the ISP shared hosting server. All SQL databases are named by them and are done to their own naming convention.
I had followed Sue and Will's advice which was to create tow SQL scripts (one for the Personal and one for the ASPNETDB) that can be imported into my ISP's Server and thereby create a single database.
I managed to do this but I am not able to edit the database or configure the necessary administrator role to give me full access to the Personal Website.
Unfortunately SQL Server 2005 express, does not have an import/export function so there is no way to export the necessary data so it can be uploaded without installing the full version of SQL Server 2005 (which I don't have).
adam, you can register first, then use sql statement manually approve yourself and assign yourself as administrator. then you have admin user name and password.
Abe
Member
10 Points
2 Posts
Re: Problems uploading Personal Website Starter Kit to Remote Server
May 05, 2006 02:29 AM|LINK
Sue
thank you for your note, but it seems that I don not have this file on my computer ,
allthough I have Visual Studio 2005,
it seems I have a long list of to-do before I manage to publish my website
thank you for your help
adamstoc
Member
40 Points
8 Posts
Re: Problems uploading Personal Website Starter Kit to Remote Server
May 05, 2006 01:57 PM|LINK
Hi Abe,
I found I didn't have this file either, and had to download and install the Microsoft SQL Server Management Studio Express.
http://msdn.microsoft.com/vstudio/express/sql/download/
See this article for some good information on exporting the database-- http://www.orcsweb.com/articles/exporting_sse_database.aspx
Regards,
Adam S
suegooge
Participant
1180 Points
235 Posts
Re: Problems uploading Personal Website Starter Kit to Remote Server
May 05, 2006 02:05 PM|LINK
tommyboy
Member
5 Points
1 Post
Re: Problems uploading Personal Website Starter Kit to Remote Server
May 05, 2006 05:04 PM|LINK
Hi Adam, I just stumbled across this thread while on my way to somewhere else. I have not read it carefully and am not nearly as attractive as Sue, but I just worked my way through similar problems with PWS and this may help you anyway. Here are a couple of things to look at:
1) It's not good if you're hosted shared server (dedicated serves are more expensive). This means that you share address space with other SQL Server and SQL Express users. You can't use the names "aspnertdb" or "Personal" if someone else has beaten you to them. You ISV can rename your DBs to something else, but this is a pain it you want to do a lot of design changes and upload the results.
2) You may need to set permissions (probably Network Service) to Read/Write/Modify/Delete on the App_Data folder so the DBs can attach the scripts and create the structure including the log file.
I decided to convert over to an Access DB to make frequent redesign and upload easier. Buzz me for more info if you want to go this route.
Good Luck!
Tom
adamstoc
Member
40 Points
8 Posts
Re: Problems uploading Personal Website Starter Kit to Remote Server
May 09, 2006 02:45 PM|LINK
Hi,
You're right about the ISP shared hosting server. All SQL databases are named by them and are done to their own naming convention.
I had followed Sue and Will's advice which was to create tow SQL scripts (one for the Personal and one for the ASPNETDB) that can be imported into my ISP's Server and thereby create a single database.
I managed to do this but I am not able to edit the database or configure the necessary administrator role to give me full access to the Personal Website.
Unfortunately SQL Server 2005 express, does not have an import/export function so there is no way to export the necessary data so it can be uploaded without installing the full version of SQL Server 2005 (which I don't have).
Any ideas?
Regards
Adam
suegooge
Participant
1180 Points
235 Posts
Re: Problems uploading Personal Website Starter Kit to Remote Server
May 09, 2006 03:02 PM|LINK
adam, you can register first, then use sql statement manually approve yourself and assign yourself as administrator. then you have admin user name and password.
adamstoc
Member
40 Points
8 Posts
Re: Problems uploading Personal Website Starter Kit to Remote Server
May 11, 2006 02:32 PM|LINK
Hi Sue,
I am not sure how to go about your suggestion, would it be possible to take me through the steps!
Regards,
Adam
suegooge
Participant
1180 Points
235 Posts
Re: Problems uploading Personal Website Starter Kit to Remote Server
May 11, 2006 02:37 PM|LINK
masterivc
Member
60 Points
12 Posts
Re: Problems uploading Personal Website Starter Kit to Remote Server
May 16, 2006 03:52 PM|LINK
adamstoc
Member
40 Points
8 Posts
Re: Problems uploading Personal Website Starter Kit to Remote Server
May 17, 2006 08:45 AM|LINK
Hi Sue,
When you say ULR, I assume you mean the default page for the website?
www.burrrenview.com/default2.aspx
Regards,
Adam