.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

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

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :


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

View Complete Post

More Related Resource Links

Installing SQL Server 2005 management studio express with Windows 7

I have bought a new laptop with windows 7 premium and i cannot install sql server management studio express. I have downloaded sp3 and i still reveive an error message that it is not compatible with the os. please help

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.



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



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


Compatibility issues between Microsoft Visual Studio 2005 and Windows Server 2008 R2


Dear sirs,

When I was installing SQL Server 2005 64 bit on Windows Server 2008 R2, I received a notice informing the software Microsoft Visual Studio 2005 has known compatibility issues with this version of Windows.

So how can I get around these problems?

I need to use Visual Studio 2005 to create the Integration Services packages.

Also, I need to migrate directories of Integration Services packages from a server with SQL Server 2005 32 bit on Windows Server 2003 32 bit for a server with SQL Server 2005 64 bit on Windows Server 2008 R2. How can I proceed to do this?

Thanks in advance.

Jose Luiz

Windows Azure: Developing and Deploying Cloud Apps in Visual Studio 2010


You'll find direct support for building Windows Azure applications in Visual Studio 2010 and Visual Web Developer 2010 Express. We'll walk you through using Visual Studio 2010 for the entirety of the Windows Azure application development lifecycle.

Jim Nakashima

MSDN Magazine April 2010

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

Visual Studio 2010 on windows 7 64 bit



Today i have xp pro with visual studio 2005 and going to change to windows 7 with 64 bit.

Will upgrade to Visual Studio 2010 with 64 bit.

Is that a problem going from visual stuidio 2005 (32bit) to visual studio 2010 (64bit) ? Anything i should think about or if anybody had problems with this ?

The server I will deploy my webapplication is windows server 2003 (32bit).
Will it be ok to deploy webapplications that are build in vs2010 (64 bit) but deployed on a server with 32 bit ?

Maybe this is obvious to some people but I have to ask cause I'm not sure about this.

Thanks in advance






Installed Visual Studio 2005 on new laptop - can't open C# web services project solution.

Installed Visual Studio 2005 on new laptop - can't open C# web services project solution - get the 'project not supported by this installation' error. Tried re-installing to no avail. Have run various flavors of devenv as recommended in various posts. Still the same message. I can open the solution fine on my old laptop.    Update: We re-installed service pack 1 for VS and the problem was resolved.

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?

Error trying to open WPF Xaml windows from Visual Studio 2010 in Blend 4

Hi I have Visual Studio 2010 ultimate, and expression Blend 4. I have created a WPF 4 project in Visual Studio and when i try to open the MainWindow.xaml file in Expression Blend 4 - i get an error stating that the file or folder is not a valid blend project. Is there something i need to install for visual studio to make blend able to edit WPF Xaml files in Blend 4? I can open blend4 and create WPF applications with no problem - its just trying to open a mainwindow.xaml created in Visual Studio 2010 in blend 4 when i get the error. I am running windows 7 32 bit. Cheers Rod. Mono / DotNet Rocks!

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

Management Studio sql 2005 Express on Windows Server 2008 r2

Hi , i have install a application that use sql server express 2005 on a server with OS windows server 2008 r2. My question is how to make automatic backup of my database , because i cant install SQL Server 2005 Management Console on my server .   Please help me Thanks

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

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.

Installing SQL Server 2005 Developer Edition (64 bit) on Windows 7 Home Premium (64 bit)

Hello All, I would like to know if I can install SQL Server 2005 Dev Edition (64 bit) on Windows Home Premium (64 bit)? I have enabled the IIS via the control panel. Is there anything else that I need to do before I start the installation? Please assist. Thanks, CD

Error installing SQL Server Management Studio Express on Windows Vista RC1

Hello NG, After installing SQL Server 2005 Express Edition on Windows Vista RC1, I wanted to install also the Managent Studio but I always receive the following error message: "Bei der Installation dieses Pakets ist ein unerwarteter Fehler aufgetreten. Es liegt eventuell ein das Paket betreffendes Problem vor. Der Fehlercode ist 29506." Where can I find more infos about this error-code? Anybody knows this problem? Thank in advance for every help.
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