I started this publishing process about a month ago. First I was informed that its as simple as a click on the build menu. This was useful and got me started. I discovered some run-time errors in the course of executing a task. I was moving my task and other information via FTP to my server. The menu I have built executes fine and the only problem I have is in running simple task involving sqlserver express. I should also note that everything works fine on my local server. I eliminated a couple of runtime errors by merely setting the framework to 4.0 on the providing host machine (as it is on my own). Finally, I got a clean bill of health when I clicked "PUBLISH". Result when I tried on the server, was missing connection strings information that I believe is included in the "WEB.CONFIG" file. One of my problems is understanding what is supposed to happen when I "Publish".
Moving on as if I know what I am doing, I FTP'd my WEB file to the remote and at least changed the error (profuse output pasted in below). Don't know where to go from here. All that I am looking for is how to configure the application to run the sqlserver related task. This is all I have sought from the get-go, and no one has given me a working answer.
My server dump is below>
I will in the meantime pass this on to my provider as it seems to be saying that a successful connection to sqlserver is not being made.
Server Error in '/' Application.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
- Moved by Jason Dot WangMicrosoft contingent staff Thursday, April 26, 2012 1:44 AM This topic is about ASP.NET (From:ClickOnce and Setup & Deployment Projects)