Wrox Programmer Forums
ASP.NET 4 General Discussion For ASP.NET 4 discussions not relating to a specific Wrox book
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 4 General Discussion section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 9th, 2015, 08:14 PM
Registered User
Join Date: Oct 2015
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Deployment Problems

I have created a web site (with help from Professional ASP.NET 4 in C# and VB) and it works fine on my local machine. When I tried to deploy to the server at my hosting company I ran into problems. It appears that VS defaults to creating the Provider databases in SqlExpress. When I tried to deploy, I got errors saying that SqlExpress wasn't installed on the server. How do I tell VS that it needs to use SQL 2008 in release, but SqlExpress in debug for the Provider databases?
Old October 9th, 2015, 10:51 PM
Registered User
Join Date: Oct 2015
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts

I have the same question so looking forward to the answer
Old October 10th, 2015, 03:48 AM
Imar's Avatar
Wrox Author
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts

Hi there,

You'll need to update your web.config and have your connection strings on the server point to a different database serve.

You can use Web Publish Config Transformations (https://msdn.microsoft.com/en-us/lib...vs.100%29.aspx) to create different versions of web.config for local development and deployment to a server.

Hope this helps,

Imar Spaanjaars
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Old October 10th, 2015, 01:46 PM
Registered User
Join Date: Oct 2015
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts

Yes, I already have different web.config files for the two environments. I think the problem I'm having is how to change the connection strings specifically for the provider databases created by VS, as opposed to the database I've created for my data. But I will look at the documents you suggest, as I'm sure there is information in there I can use.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Permission Problems on Deployment Hank_Marietta BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 3 August 22nd, 2007 12:29 PM
Deployment Problems rssimmons BOOK: Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter ISBN: 978-0-7645-8807-5 1 August 12th, 2007 10:05 PM
deployment p2pMember ASP.NET 2.0 Basics 0 June 7th, 2007 01:12 AM
Deployment problems drb2k2 ASP.NET 2.0 Basics 2 May 9th, 2006 04:15 AM
Deployment regbnvl BOOK: Professional VB 2005 ISBN: 0-7645-7536-8 0 May 7th, 2006 04:44 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.