I’m using a shared hosting provider, and uploading data from a local database to live is not easy, so I wanted to know; can I configure a new ASP.NET 2.0 web application to use a specific database on another web server? Can this database then be used if I started using login controls – as in, would all the relevant data be copied to the remote database?

I hope the answer is yes, and if so how? Would I need to write the config file first? What would I need to add to avoid a local instance of ASPNETDB.mdf being created and my remote database being used instead?

Many thanks
Richard