I created an asp.net app that uses a database and it works fine locally, however, I am not sure how to access the database once it has been uploaded to my web site.  The company that hosts my site is ix web hosting.  My connection string before I uploaded the web site is

  connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\SM.mdf;Integrated Security=True;User Instance=True"

Can someone please help me edit my connection string so I can access my database and make any other necessary adjustments?

Does your web hosting company support Sql Server Express?  Have you asked them for guidance? Do they provide a FAQ for this kind of thing?

Hi,

I think it depends upon which SQL Server Edition of host server is using. If it is SQL Server Express version, we can upload your express database, such as aspnetdb.mdf file (which is in the app_data folder) to server directly.

If it is SQL Server 2005, we can either use aspnet_regsql utility to recreate database on server and import data, or use your existed database to create .SQL Installation Scripts and then use this .SQL files to create Database on Server.

Besides, please don't forget to modify connection to point to new database in web.config.
For more information, see (Deploying a SQL Database to a Remote Hosting Environment) http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx
 

 
I look forward to receiving your test results.