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.
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