am i being completely naive?

ok.....fairly new to this......

i built a website on my local machine using visual web developer express 2008
and it uses a sqlexpress .mdf file as the database.

i notice that visual web developer express 2008 has a "copy database" feature where i can ftp a website to a hosting account.

am i being naive to think i can just ftp the site up to my discountasp.net account and presto-chango it will run???

also....why is it that when i try to open an ftp connection i get this message:

530 User cannot log in, home directory inaccessible

???

 

apparently i wasn't so naive.....
it works except.......doesn't know how to connect to the database

in my local web.config I have:

<add name="MyDatabaseName" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"

but i don't know what it should be for my site on DiscountAPS.Net

the error:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

anyone know how i can get my app to work with my sqlexpress .mdf file?

 

Unfortunately we do not support SQL Express databases as they are meant for local environments.

You can however create a backup of your database(.bak) and restore it to a SQL database add-on if you have purchased one for your account. We also have an attach tool for .MDF files if you rather upload it in that format.

You can order an add-on through the order add-ons page of your control panel:

https://my.discountasp.net/addons/

 

i ordered the ad-on sql server 2005 database
i tried the "attach" but it failed and said "contact tech support"

i noticed during the "attach" process it said "warning - this will overwrite your sql server 2005 database". so i'm assuming there wouldn't be a problem that my mdf file was a sql server express 2008 file.

or would there be?