Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jun 19, 2006 02:05 AM by suegooge
May 05, 2006 02:29 AM|LINK
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
May 05, 2006 01:57 PM|LINK
I found I didn't have this file either, and had to download and install the Microsoft SQL Server Management Studio Express.
See this article for some good information on exporting the database--
May 05, 2006 02:05 PM|LINK
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.
May 09, 2006 02:45 PM|LINK
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).
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.
May 11, 2006 02:32 PM|LINK
I am not sure how to go about your suggestion, would it be possible to take me through the steps!
May 11, 2006 02:37 PM|LINK
May 16, 2006 03:52 PM|LINK
May 17, 2006 08:45 AM|LINK
When you say ULR, I assume you mean the default page for the website?