• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 670
  • Last Modified:

How to publish an ASP.net site with a Sql Server Express database to a web server?

I'm hoping to publish my asp.net website to a site that will host it for free or cheap.  I also have a sql server express database on there that is fairly small in size.  Can anyone help me out with where I might go to get this hosted and how to publish it??

Thank you in advance!!
1 Solution
most providers offer you some space on their sqlserver.
You can connect with your sql express to that server and create your tables etc. to a database that the provider will tell you.
Then you can connect from your application to the database by changing your connection string.
If you use the role-database that is provided by certain asp.net templates, those databases can simply be uploaded to the special folder like it is located on your local project directory structure. Sometimes you will need to create the folder on your providers server. Simply create it via ftp or so.
kpbaremAuthor Commented:

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now