Where is the SQL Server MDF database once deployed in production?

Hello everyone,
I've developed a website project in VS2010 that includes the ASPNETDB.MDF database. In the project package/publish settings I select the option Exclude files from App_Data folder and when importing the package into IIS7.5 the database is located in the Users\AppData\... folder. So far so good, however I have the following questions:
Q1 - Importing the project into IIS7.5 works and the database is created successfully but my connectionString syntax in the web.config seems not correct since it causes an error on pages that have SQL DataSource objects. The error is: Invalid value for key 'attachdbfilename'. The connection string is:
Data Source=localhost\SQLExpress;AttachDBFilename=|DataDirectory|\XYZWebDBTST20.mdf;Initial Catalog=XYWebDBTST20;User ID=XYZWebDBUser;Integrated Security=SSPI;Persist Security Info=False Q2 - When I finally upload the package to the web where will t ...