Install both SQL Server 2005 Developer and SQL Express on same mac

I currently have Visual Studio 2005 and SQL Server 2005 Developer installed
on my XP Professional PC. I'm trying to create a Visual Studio project that
uses a local database within the application. When I try to add the SQL
database "item" to my project, I get the following error: "Connections to SQL
Server files (*.mdf) require SQL Server Express 2005 to function properly.
Please verify the installation of the component or download from the URL
http://go.microsoft.com/wlink/?linkID=49251"
I understand that SQL Express is required so I can deploy the application to
a customer's PC that does not have SQL Server installed, and since SQL
Express is free, it's the logical choice for this sort of application. My
problem comes when I try to install SQL Express on my PC. Every time I
attempt to install, it wants to completely remove SQL Server 2005 Developer.
I keep reading that I can have both editions installed on one machine, but I
can't figure out how to do it. I don't want to uninstall the Developer
edition. Can anyone out there please explain how I can do it?
Thanks.You certainly can install both SQL Server2005 full version and SQL Server
Express on the same computer. However, if you have the developer edition
installed already, you probably do not need to install SQL Server Express to
take up your crowded disk drive space.
I strongly suggest you to do some study on SQL Server, if you are to use it
in your development. The said error message is caused by using "User
Instance" feaure, only available to SQL Server Express, which you probably
do not need to use (unless you do know what User Instance is and have to use
it in your application).
SQL Server is installed on a computer by instance, and multiple instances
are allowed. Only one instance can be default instance, meaning uses
computer name as SQL Server's instance name, all other SQL Server
installations have to be named instance (in the form of "ComputerName\SQL
ServerInstanceName").
"ginacresse" <ginacresse@.discussions.microsoft.com> wrote in message
news:6E2CB76C-BD03-47E5-B3EB-B0A26834B8F7@.microsoft.com...
>I currently have Visual Studio 2005 and SQL Server 2005 Developer installed
> on my XP Professional PC. I'm trying to create a Visual Studio project
> that
> uses a local database within the application. When I try to add the SQL
> database "item" to my project, I get the following error: "Connections to
> SQL
> Server files (*.mdf) require SQL Server Express 2005 to function properly.
> Please verify the installation of the component or download from the URL
> http://go.microsoft.com/wlink/?linkID=49251"
> I understand that SQL Express is required so I can deploy the application
> to
> a customer's PC that does not have SQL Server installed, and since SQL
> Express is free, it's the logical choice for this sort of application. My
> problem comes when I try to install SQL Express on my PC. Every time I
> attempt to install, it wants to completely remove SQL Server 2005
> Developer.
> I keep reading that I can have both editions installed on one machine, but
> I
> can't figure out how to do it. I don't want to uninstall the Developer
> edition. Can anyone out there please explain how I can do it?
> Thanks.|||On Jul 25, 4:29 pm, "Norman Yuan" <NotR...@.NotReal.not> wrote:
Thank you Norman Yuan.
I will keep what you said in mind for future reference.
Just the other day, I too tried to install SQL Server 2005 Developer
Edition onto my XP Pro machine, which already has the SQL Server 2005
Express (Free) edition, and the installation failed at the very end--
$50 wasted buying the Developer edition. But so far I've not missed
Developer Edition anyway in my software programming (differences
between the editions found here: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
, with Developer being like Enterprise for the most part)
RL