Saturday, June 21, 2008

QSH Database Setup

How to create and use a database - MS SQL 2005 Express Edition (User Instances only) - FAQ Freehosting - Quantasoft ASP.NET Webhosting

To successfully use SQL Express database in ASP.Net application, hosted at QSH, keep in mind the following tips:
  • Database name should be unique. Generate the connection string and add it to the web.config.
  • Use <remove name="LocalSqlServer" /> if you use LocalSqlServer as the connection name.
  • If using a custom connection string within the application, it should be named the way the DB name is generated on the admin page (domain_guid).
  • Upload only .mdf file, without log (.ldf)
That's it. The db connection works great.

No comments: