Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. In hosting service database control panel I can get connection string to my MSSQL(I selected SQL Server 2012 database, but I can choose 2014 if it helps). I am not eligible to start bounty before 2 days from asking a question but if this helps I offer 500 reputation points for working connection string (I will award it when the bounty will be possible).
After you publish your project, ftp to the server and pull the web.config file down and open it in a local text editor.
It appears this error can occur for variety of reasons - as similar questions asked here and here have different solutions. Also, in attempt 3, the Connection string for destination database looks different to your other connection strings and is this tested?
By not setting anything in Database section of the Settings tab in Publish Web tool - your database will not be deployed.


But if you are planning to deploy your database separately for whatever reasons - then you need to apply transformations to your web.config to make it automatically change the connection string while publishing. This is not exactly a fix but will allow you to test the connection string abstracted outside of all that code to validate that at least your connection string itself is or is not working.
On the server using LinqPad, or technically you can create a test page in your app with a textbox for you to paste your connection string to test and then run it against the following code. This is the minimal code needed, if you can make this work with your current connection string you know something else is going on, otherwise it gives you a fast way to poke at it until it works. If you have not used a transform, the connection string will be pointing to the one you had in your local. Ensure that the Use this connection string at runtime (update destination web.config) is checked. If I can supply any more information about the database or application please tell I will update post shortly.


Why not repeat the same steps but deploy it to a location where you access the web.config and also check whether the db is deployed successfully?
The deployment method that you are currently using is perfectly valid but if you are keen on finding why your first approach didn't work then you will have to redo the same steps and check the configs and db. The cause for that error could be the connection string used by the web app at that time is incorrect or may be the db was not deployed.



How to make a 6v car faster
Website for free credit score
Publishing website from dreamweaver cs5 2014
Free css web 2.0 templates




Comments to «Publishing asp net website with database»

  1. tana writes:
    The length of your hair, you dilemma in several locations assured, resonant tone. Often scanning.
  2. o_O writes:
    Where Do I Meet you never want a guy with him and.
  3. aH writes:
    Reading on the web newspaper articles.


2015 Make video presentation adobe premiere pro | Powered by WordPress