.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Web Application Deployment with Visual Studio 2010 and SQL Server 2005?

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :Windows Application


Is it possible to do a web application deployment(create package/publish sql & package/publish web) with Visual Studio 2010 and SQL Server 2005?

I'm trying my  hand at this new feature - I have an application created in VS2010 and the backend is SQL Server 2005

I read on msdn that the pre-requisites for the database part of the web application deployment is SQL Server Express 2008 or later versions for the tutorial they posted...Is that mandatory for any deployments??

Thanks for your help! Smile


View Complete Post

More Related Resource Links

CLR Deployment issue sql server 2008 r2 visual studio 2010



 i am getting the following error while deploying the clr project converted frm vs2008 to vs2010. Please help me


Compile complete -- 0 errors, 24 warnings

Bloomberg_WSDL -> D:\Projects\STP\Development\BBG-WSDL\SS-BBG-WSDL\bin\Release\Bloomberg_WSDL.dll

------ Deploy started: Project: Bloomberg_WSDL, Configuration: Release Any CPU ------

Build started 11/22/2010 7:07:50 PM.


Beginning deployment of assembly Bloomberg_WSDL.dll to server : stpQA01

C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v10.0\TeamData\Microsoft.Data.Schema.SqlClr.targets(96,5): error : Could not connect to server stpQA01 : Login failed for user 'stpuser'.


Time Elapsed 00:00:00.07

========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========

========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========


Deployment issue using SQL CLR, visual studio TFS GDR 2, SQL Server 2005.


I have a solution project that consists of database project, CLR database project, C# projects. The database project references the CLR database project. Thus, by clicking deploy on the database project will auto-deploy all projects under the solution. It is successfully depolyed locally to either SQL Server 2005/2008 wihtout TFS GDR 2.

However, in addition to those compoments, on the staging server, there are TFS GDR 2 and the Windows Server running on virtual machine. The deployment failed. The reason is that my custom SQL CLR assembly that is loaded into database requires other additonal assemblies. Those assemblies have a dependent hierarchy, which requires deletion in a certain sequence (e.g. assemblyA depends on assemblyB, thus, assemblyB must be deleted from database first before deleting assemblyA.). When the deployment happens on the staging server, the generated database tsql script try to delete those assemblies, but in a wrong way/sequence. That is the reason it failed. As I said, it is working locally. But local deployment has no TFS GDR2 and virtual machine server, which might or might not be the cause. Because the auto-generated database script is done via visual studio.

I have tried using the pre/post deployment script, but it still failed on staging server.  We want to auto-deploy the solution for staging and production server.

installing SQL Server 2005 on Windows 7 with Visual Studio 2010 already installed



Last year I had Vista on machine with Visual Studio 2008 and SQL Server 2005 running fine. Last week I decided to wipe the hard disk, install Windows 7 and make the move to Visual Studio 2010. I still need SQL Server 2005 to be able to test code for clients using this.

Anyway, Visual Studio 2010 Professional went on OK. This installed SQL Server 2008 Epxress.

I then try to install SQL Server 2005. I know that there is a compatibility problem, so following advice from other sources, I want to install it without running the server, then install SQL Server 2005 SP3. Then I should be up and running.


The problem is that even though I make sure the 'Start SQL Server' check box is UNchecked, part way through the installation it throws up an error saying it can't start the server and this part of the installation is unrolled.

I've tried running 'setup.exe SKUUPGRAGE=1' which gets rid of the only warning I was getting up to this point, but the setup seems to insist on running the server even though I tell it not to. So I don't get a chance to run SP3 on it.


I wonder if the problem is that SQL Server 2008 Epxress is already installed but can't see an easy way of uninstalling it. It doesn't appear as an uninstall option using the Visual Studio 2010 disk and if I look at uninstall programs I get the f

Use The Source, Luke: Source Server Helps You Kill Bugs Dead In Visual Studio 2005


The latest releases of WinDBG and Visual Studio know exactly how to use source server, so its benefits are available to both .NET and native C++ developers. See why this is so important in tracking down bugs.

John Robbins

MSDN Magazine August 2006

Video: SharePoint 2010 Solution Deployment in Visual Studio 2010

This video delves into the details of packaging and deployment for SharePoint solutions in Visual Studio 2010. (Length: 9:16)

Using a SQL Server CE database in Visual Studio 2010

I am working on a VS 2010 C# project that is supposed to connect to a Sql Server 2008 CE 3.5 database.  I added the database to the project, and am trying to establish a new SqlConnection. The directory path of the database is: W:\MCT\Development\LocalReportExample\LocalReports\TestCEDatabase.sdf  I am trying to set my ConnectionString as follows: test = @"Data Source=W:\MCT\Development\LocalReportExample\LocalReports\TestCEDatabase.sdf"; connection.ConnectionString = test; connection.Open();  When the code executes, it throws an error message stating that the database was not found, or is inaccesible.  Is my ConnectionString wrong?  Is there possibly something I haven't configured correctly in the database setup?

Trouble With Team Foundation Server/Visual Studio 2010

Hi At work we are 2 guys on the same project. We both program in visual studio 2010. The other guy complains that he don't see my changes. I know this dude have already executed "Get Latest Version", despite that he don't get my changes. Some more information that may be relevant:Each time I've done some changes to the source code on my local computer, when I run the code breakpoints are not triggered. I get a message saying something about mismatch between different version of the source (or something like that, weeks sinece I saw that message). It's a while since I saw that message becasue I've found a work-around: Each time I've done changes tothe source code I do this:- Clean Solution- Rebuild (Release)- Rebuild (Debug) When I've done that I can see my own changes.. But the other guy have trouble with seeing my changes. I'm not sure how to fix it so that he see my changes. I checkin regulary so my changes should be available on the Team Foundation Server. Any help on this would be very helpful

Visual Studio 2010, MVC2.0, IIS7, .NET4 deployment problem

I have a problem where I can get an MVC2.0 application using .NET3.5 running in IIS, but when I upgrade it to .NET4.0, the browser just reports error 500 Internal Server Error. The problem is easy to replicate as follows.  Firstly, to show it works with .NET3.5: Create a new MVC2.0 application in Visual Studio 2010, using the inbuilt starter template. Run the application using the development server, and the Home & About pages display fine. Publish the application to a directory. Copy the directory to a subdirectory under inetpub/wwwroot on my Vista computer, running IIS7 Create a new application in IIS Manager & select the DefaultAppPool (integrated pipeline) Browse the application and Home & About pages are displayed. Then the problem I have is after upgrading to .NET4.0: Change to .NET4.0 for the project in Visual Studio Build & this runs fine with the development server. Publish the application & set up IIS as before, except choosing the application pool ASP.NET v4.0 (integrated pipeline) Browse the application, and I get the 500 Internal Server Error I'm guessing there is some extra configuration required - can anyone help? I've deliberately used the default MVC installation to eliminate any variables caused by my programming .. Thanks in advance, Steve

Visual Studio 2010 can't find the Sharepoint Foundation 2010 Server when compiliing, Standalone vs

I'm wondering if we installed Visual Studio correctly cos when we get into Visual Studio 2010 the "Deploy as a Farm Solution" is the only available button option and the "Deploy as a Sandbox Solution" is un-selectable, grayed out, assuming the "Sandbox" solution is the "Standalone" approach? So when we go to compile a Workflow, the error message says the Sharepoint Server is not found" Could this "Deploy as Farm Solution" be a problem when we were instructed to install Sharepoint 2010 Foundation as a "Standalone" install? in other words we're trying to find out why when we go to compile a Workflow in Visual Studio 2010 that it can't find the Sharepoint Server Step 3: Install SharePoint 2010 1.  To install SharePoint Server 2010 or SharePoint Foundation 2010, open a Command Prompt window, and then type the following at the command prompt: On the Choose the installation you want page, click Standalone to install everything on one developer workstation. Thanks very much for any suggestions, ideas or pointers! BobK

Is it possible to use a frameset in a Visual Studio 2010 Asp.NET MVC application

A reply to the following post says not:http://forums.asp.net/p/1563210/3879572.aspxIf it is possible, can anyone point me at an example?I'll hasten to add that I've not yet tried this yet - I'm just looking for advice as to if it's possible and if so, the best approach. For instance if using a frameset, is it recommended to have a master page?TIA,Mike

Visual Studio 2010 Lab Environment for Student to deploy to a IIS 7.5 web server with SQL 2008

Currently the environment I am trying to create is a teaching lab for Visual Studio 2010 and ASP.NET website development. The intent is to setup an environment where students can create a website with an attached database written with the assistance of Visual Studio 2010. When the website is completed they need to use one of the Visual Studio deploy technologies to upload the website to a locally run server (Windows 2008 R2 with IIS 7.5 running and SQL Server 2008.) I am responsible for setting up the correct deploy technology in Visual Studio as well as setting up the IIS 7.5 deployment server that is running the right version of SQL Server. I have already started this process and figured out how to configure a deployment package in visual studio and have it published on our local server. I am trying to get a very streamlined environment that does not require students have to configure a lot of SQL strings and IIS settings because this is not really what the teaching lab is all about. Just to let you know, we have had  this exact setup using Visual Studio 2008, Server 2003 with front page server extensions on IIS 6.0 and SQL Server Compact edition running on the server. My issue is that since it is now time to update everything there does not seem to be something comparable. Any help would be greatly appreciated. If someone has an idea of the 

How to start SQL Server 2005 (Visual Studio 2008)

I am just starting to work with Visual Studio 2008 (VB) to creat WPF apps and am trying to work with sql server. I want to create databases on my computer to be used with single client applications. When I try to see if the server is running it doesn't appear to be. Is there some special process that I need to do to start the server so I can create some sample databases to work with in Visual Studio? Working with Windows XP, Visual Studio 2008, SQL Server 2005.

Create web application in Visual Studio 2010

Hi,I have a directory with sources of a web application (developed with visual studio 2008) without solution's files.Now I want to create a new web application in visual studio 2010, whit the existing sources.how can I do it?

How to add Sharepoint dll reference to Windows Forms application project in Visual Studio 2010?

Hi,I am using Windows Forms application template in Visual Studio 2010 Beta. I created this for some R & D work. Now I am using Sharepoint object model in application. When I am trying to add Sharepoint dll reference from .NET tab, I can not see Windows Sharepoint Services there Which was available in Visual Studio 2005.Also If I am add this sharepoint dll from ISAPI folder (14 Hive), it is added succesfully, but it is not taking actually in project and showing me an error during running mode that theError 12 The type or namespace name 'SharePoint' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?) Please suggest me how to add Sharepoint dll reference in Windows forms application in Visual Studio 2010?

Import Visual Studio 2005 to 2010



I am updating/extending a site I originally created in Visual Studio 2005. My new site I am starting in 2010. If I select add exiting item to project I notice a number of differences. 

1. CodeFile has been replaced by CodeBehind (without changing this, any code goes in script on the aspx page, not the .cs file. Why?

2. There is a file called filename.designer.cs created with new pages that my imported pages do not have. What is the purpose of this file and is it required and/or how can it be constructed from imported content?

thanks in advance

Windows XP, Visual Studio Express 2010 and SQL Server 2008 Express - How can I save modified columns



I am using c# in VS 2010 Express. I have a MDF database that I connect to through "Database Explorer". Database Explorer will not let me SAVE columns that I have modified. As I know in SQL Server 2008 full edition you can change the setting "Prevent saving changes that require table recreation" in Management Console to prevent this. I haven't got Management Console and can't see it in install.

How do I change this setting if I haven't got management console? Is it in Registry or Config File.



SQL Server 2008 R2 Developer with Visual Studio 2010 Pro always defaults using SQLEXPRESS


I had un-installed SQL Server 2008 Express that came with the Visual Studio 2010 Pro.

I had installed SQL Server 2008 R2 Developer, and Im able to connect through the Management Studio and Visual Studio itself.

The problem is: whenever I create a new ASP.NET Web Application, the web.config always defaults using SQLEXPRESS.

How can I change this within Visual Studio 2010 so that the web.config defaults to the new database SQL Server 2008 R2 Developer that I installed?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend