Quote:
|
Originally Posted by Will
My hypothesis is :-
It would appear to me that when running locally, the starter kit website uses my installation of SQL 2005 Express Edition, but when I upload all the files, I'm guessing the application is still trying to point at a local instance of SQL on my local PC which it now cannot see. I'm guessing I need to somehow upload the SQL database onto my web host (I've purchased 100M of SQL Server 2005 space), and point the application at that SQL instance instead. But I don't know if I'm right about all this, or indeed how to do it if I am.
Can anyone help?
Much thanks in advance,
Will
|
Looks like your hypothesis is probably correct,
does M$ provide a wizard to migrate all the info including the database ? When you say you upload all the files by ftp does this include the database files ?
what tools has your host got for managing SQL server ?, if you have access via Enterprise Manager then you could take the existing database off line , back it up , ftp it to the host and reload it from the backup that would get the data in the right place.
(They must have something that allows you to do that kind of functionality) You would then have to ensure that the username/pw that the web app is using to talk to the server had access to that instance of sql server.
Given its m$ there is probably a wizzard to do just that. or has your host got a help/suport page
hope that helps point you in a useful direction