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

install analysis services on sql server 2005 workgroup

I made an analysis services project but I can't deploy it because it can't find the server
I search for the analysis service in the Service Control Manager but I can't find it.
Is it possible to download and install it with this version of sql server (workgroup) ?SQL Server 2005 does not contain Analysis Services. If you wish to use Analysis Services features you'll have to upgrade to Standard Edition. For further information about features in the various editons of SQL Server, you may have a look at SQL Server 2005 Features Comparison (http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx)|||thank you
I hope that there's an upgrade.

Inside a project you lose the control?

I've got a project with 12 packages. One of them runnning and at the same time when I try to alter another one or even add a new task I see that all the tasks on toolbox are disabled.

Why?

I would like to hear a good reason for this behaviour, afaik I don't get the point...

Often the packages in one project call into each other, so if one of them is currently executing - there is a good chance others will be running as well. Although I agree this might be too restrictive sometimes - please file a suggestion to relax this behavior for next version.|||

Michael Entin - MSFT wrote:

please file a suggestion to relax this behavior for next version.

suggestions may be submitted here: https://connect.microsoft.com/feedback/default.aspx?SiteID=68