Dual installation SQL 2005 Std. and Express

Hi everybody,
I had SQL 2005 std. edition installed and I install SQL 2005 express
after that. I have no trace of the express installation. Neither in the
add/remove program nor under \Program files directory!
Is dual installation possible?
Are files copied to the same directories?
thank you very much
sergeHi,
I found that I had to install SQL Server Management Studio Express (SSMSE)
but it cannot be installed when SQL Server Management Studio standard
edition is already installed. How can'I remove SSMS? It does not appear in
the add/remove program. And the Microsoft warning messsage shown during the
installation of SSMSE is truncated!
thank you for your time
serge
Serge Myrand wrote:
> Hi everybody,
> I had SQL 2005 std. edition installed and I install SQL 2005 express
> after that. I have no trace of the express installation. Neither in the
> add/remove program nor under \Program files directory!
> Is dual installation possible?
> Are files copied to the same directories?
> thank you very much
> serge|||> Is dual installation possible?
>
Yes, you can install both. The add/remove programs entry is shared. You
can selectively change/remove instances using the single entry.
> Are files copied to the same directories?
The default location is "C:\Program Files\Microsoft SQL Server". You will
have numbered subfolders(e.g. MSSQL.4) for instance-specific items.
Hope this helps.
Dan Guzman
SQL Server MVP
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:44142941.EA94C30F@.softdelirium.qc.ca...
> Hi everybody,
> I had SQL 2005 std. edition installed and I install SQL 2005 express
> after that. I have no trace of the express installation. Neither in the
> add/remove program nor under \Program files directory!
> Is dual installation possible?
> Are files copied to the same directories?
>
> thank you very much
> serge
>Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!|||No need for SSMSE in this case since you can use SSMS for the SQL Express
instance. For example, connect to instance 'MyServer\SQLExpress'.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:44143B91.DA5D61B0@.softdelirium.qc.ca...
> Hi,
> I found that I had to install SQL Server Management Studio Express (SSMSE)
> but it cannot be installed when SQL Server Management Studio standard
> edition is already installed. How can'I remove SSMS? It does not appear in
> the add/remove program. And the Microsoft warning messsage shown during
> the
> installation of SSMSE is truncated!
> thank you for your time
> serge
>
> Serge Myrand wrote:
>> Hi everybody,
>> I had SQL 2005 std. edition installed and I install SQL 2005 express
>> after that. I have no trace of the express installation. Neither in the
>> add/remove program nor under \Program files directory!
>> Is dual installation possible?
>> Are files copied to the same directories?
>> thank you very much
>> serge
>|||Thank you very much.
Dan Guzman wrote:
> > Is dual installation possible?
> >
> Yes, you can install both. The add/remove programs entry is shared. You
> can selectively change/remove instances using the single entry.
> > Are files copied to the same directories?
> The default location is "C:\Program Files\Microsoft SQL Server". You will
> have numbered subfolders(e.g. MSSQL.4) for instance-specific items.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
> news:44142941.EA94C30F@.softdelirium.qc.ca...
> > Hi everybody,
> >
> > I had SQL 2005 std. edition installed and I install SQL 2005 express
> > after that. I have no trace of the express installation. Neither in the
> > add/remove program nor under \Program files directory!
> >
> > Is dual installation possible?
> >
> > Are files copied to the same directories?
> >
> >
> > thank you very much
> > serge
> >Neither in the
> > add/remove program nor under \Program files directory!Neither in the
> > add/remove program nor under \Program files directory!Neither in the
> > add/remove program nor under \Program files directory!Neither in the
> > add/remove program nor under \Program files directory!

Dual installation SQL 2005 Std. and Express

Hi everybody,
I had SQL 2005 std. edition installed and I install SQL 2005 express
after that. I have no trace of the express installation. Neither in the
add/remove program nor under \Program files directory!
Is dual installation possible?
Are files copied to the same directories?
thank you very much
serge
Hi,
I found that I had to install SQL Server Management Studio Express (SSMSE)
but it cannot be installed when SQL Server Management Studio standard
edition is already installed. How can'I remove SSMS? It does not appear in
the add/remove program. And the Microsoft warning messsage shown during the
installation of SSMSE is truncated!
thank you for your time
serge
Serge Myrand wrote:

> Hi everybody,
> I had SQL 2005 std. edition installed and I install SQL 2005 express
> after that. I have no trace of the express installation. Neither in the
> add/remove program nor under \Program files directory!
> Is dual installation possible?
> Are files copied to the same directories?
> thank you very much
> serge
|||> Is dual installation possible?
>
Yes, you can install both. The add/remove programs entry is shared. You
can selectively change/remove instances using the single entry.

> Are files copied to the same directories?
The default location is "C:\Program Files\Microsoft SQL Server". You will
have numbered subfolders(e.g. MSSQL.4) for instance-specific items.
Hope this helps.
Dan Guzman
SQL Server MVP
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:44142941.EA94C30F@.softdelirium.qc.ca...
> Hi everybody,
> I had SQL 2005 std. edition installed and I install SQL 2005 express
> after that. I have no trace of the express installation. Neither in the
> add/remove program nor under \Program files directory!
> Is dual installation possible?
> Are files copied to the same directories?
>
> thank you very much
> serge
>Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!
|||No need for SSMSE in this case since you can use SSMS for the SQL Express
instance. For example, connect to instance 'MyServer\SQLExpress'.
Hope this helps.
Dan Guzman
SQL Server MVP
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:44143B91.DA5D61B0@.softdelirium.qc.ca...
> Hi,
> I found that I had to install SQL Server Management Studio Express (SSMSE)
> but it cannot be installed when SQL Server Management Studio standard
> edition is already installed. How can'I remove SSMS? It does not appear in
> the add/remove program. And the Microsoft warning messsage shown during
> the
> installation of SSMSE is truncated!
> thank you for your time
> serge
>
> Serge Myrand wrote:
>
|||Thank you very much.
Dan Guzman wrote:
[vbcol=seagreen]
> Yes, you can install both. The add/remove programs entry is shared. You
> can selectively change/remove instances using the single entry.
>
> The default location is "C:\Program Files\Microsoft SQL Server". You will
> have numbered subfolders(e.g. MSSQL.4) for instance-specific items.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
> news:44142941.EA94C30F@.softdelirium.qc.ca...

Dual installation SQL 2005 Std. and Express

Hi everybody,
I had SQL 2005 std. edition installed and I install SQL 2005 express
after that. I have no trace of the express installation. Neither in the
add/remove program nor under \Program files directory!
Is dual installation possible?
Are files copied to the same directories?
thank you very much
sergeHi,
I found that I had to install SQL Server Management Studio Express (SSMSE)
but it cannot be installed when SQL Server Management Studio standard
edition is already installed. How can'I remove SSMS? It does not appear in
the add/remove program. And the Microsoft warning messsage shown during the
installation of SSMSE is truncated!
thank you for your time
serge
Serge Myrand wrote:

> Hi everybody,
> I had SQL 2005 std. edition installed and I install SQL 2005 express
> after that. I have no trace of the express installation. Neither in the
> add/remove program nor under \Program files directory!
> Is dual installation possible?
> Are files copied to the same directories?
> thank you very much
> serge|||> Is dual installation possible?
>
Yes, you can install both. The add/remove programs entry is shared. You
can selectively change/remove instances using the single entry.

> Are files copied to the same directories?
The default location is "C:\Program Files\Microsoft SQL Server". You will
have numbered subfolders(e.g. MSSQL.4) for instance-specific items.
Hope this helps.
Dan Guzman
SQL Server MVP
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:44142941.EA94C30F@.softdelirium.qc.ca...
> Hi everybody,
> I had SQL 2005 std. edition installed and I install SQL 2005 express
> after that. I have no trace of the express installation. Neither in the
> add/remove program nor under \Program files directory!
> Is dual installation possible?
> Are files copied to the same directories?
>
> thank you very much
> serge
>Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!|||No need for SSMSE in this case since you can use SSMS for the SQL Express
instance. For example, connect to instance 'MyServer\SQLExpress'.
Hope this helps.
Dan Guzman
SQL Server MVP
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:44143B91.DA5D61B0@.softdelirium.qc.ca...
> Hi,
> I found that I had to install SQL Server Management Studio Express (SSMSE)
> but it cannot be installed when SQL Server Management Studio standard
> edition is already installed. How can'I remove SSMS? It does not appear in
> the add/remove program. And the Microsoft warning messsage shown during
> the
> installation of SSMSE is truncated!
> thank you for your time
> serge
>
> Serge Myrand wrote:
>
>|||Thank you very much.
Dan Guzman wrote:
[vbcol=seagreen]
> Yes, you can install both. The add/remove programs entry is shared. You
> can selectively change/remove instances using the single entry.
>
> The default location is "C:\Program Files\Microsoft SQL Server". You will
> have numbered subfolders(e.g. MSSQL.4) for instance-specific items.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
> news:44142941.EA94C30F@.softdelirium.qc.ca...

Dual Core Processor

We are in process of moving to 64 bit HP servers with sql2005 standard
edition. We were just wondering which is better option, to get a server with
2 dual core processor or to get a srver with just 4 processor? How does
SQL2005 handle the hypertheading of dual processor?
Thanks,
CarlosDual core processors and hyperthreaded processors are totally different
things. Hyperthreading actually adds a "virtual" core, and is not leveraged
very well by SQL Server. Multicore processors, on the other hand, actually
behave like multiple processors -- two cores gives you two processors worth
of power. The great thing in terms of SQL Server licensing is that you only
need to pay per socket, rather than per core. So buying two dual core
processors will save you a substantial amount of money over buying four
single-core processors. And now you can buy quad-core processors, so why
not just get ONE of those?
Adam Machanic
SQL Server MVP - http://sqlblog.com
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"Carlos" <carlosarango@.SQLserver.com> wrote in message
news:EB6E4323-8944-476E-A01B-D85B158BBB3F@.microsoft.com...
> We are in process of moving to 64 bit HP servers with sql2005 standard
> edition. We were just wondering which is better option, to get a server
> with
> 2 dual core processor or to get a srver with just 4 processor? How does
> SQL2005 handle the hypertheading of dual processor?
> Thanks,
> Carlos|||Thanks Adam, that makes sense
"Adam Machanic" wrote:
> Dual core processors and hyperthreaded processors are totally different
> things. Hyperthreading actually adds a "virtual" core, and is not leveraged
> very well by SQL Server. Multicore processors, on the other hand, actually
> behave like multiple processors -- two cores gives you two processors worth
> of power. The great thing in terms of SQL Server licensing is that you only
> need to pay per socket, rather than per core. So buying two dual core
> processors will save you a substantial amount of money over buying four
> single-core processors. And now you can buy quad-core processors, so why
> not just get ONE of those?
>
> --
> Adam Machanic
> SQL Server MVP - http://sqlblog.com
> Author, "Expert SQL Server 2005 Development"
> http://www.apress.com/book/bookDisplay.html?bID=10220
>
> "Carlos" <carlosarango@.SQLserver.com> wrote in message
> news:EB6E4323-8944-476E-A01B-D85B158BBB3F@.microsoft.com...
> > We are in process of moving to 64 bit HP servers with sql2005 standard
> > edition. We were just wondering which is better option, to get a server
> > with
> > 2 dual core processor or to get a srver with just 4 processor? How does
> > SQL2005 handle the hypertheading of dual processor?
> >
> > Thanks,
> >
> > Carlos
>

Dual Core Processor

We are in process of moving to 64 bit HP servers with sql2005 standard edition. We were just wondering which is better option, to get a server with 2 dual core processor or to get a srver with just 4 processor? How does SQL2005 handle the hypertheading of dual processor?

Thanks,

CarlosWe are in process of moving to 64 bit HP servers with sql2005 standard edition. We were just wondering which is better option, to get a server with 2 dual core processor or to get a srver with just 4 processor? How does SQL2005 handle the hypertheading of dual processor?

Thanks,

Carlos
How about a Quad processor?

First; it will reduce the load on the mother board's Memory Bus. AMD's data-sheet on 4-core mention that "competitors" (Intel) behave more like two duo-core processors on the same backplane, but I'm not sure how far that goes but it implies that performance wise (at the hardware layer) that Intel 2-Core is similar to two 2-Core processors.

Second; Microsoft only counts it as a single CPU. So; anything licensed (from MS) by CPU will save substantially on licensing fees.

I don't have the link, so here's the quote:

SQL Server Multicore Licensing Policy
Published: August 1, 2005

Multicore processors, which consist of multiple processing execution
units or "cores" on one chip, promise to boost computing power, allowing
servers, workstations, and PCs to perform more functions simultaneously.
By the end of 2006, Intel expects more than 80 percent of its server
products to be shipping with multicore technology. Because most
server-side software is licensed "per processor," it has caused
confusion among some software vendors regarding whether to charge their
customers "per processor" or "per core."

Microsoft has been driving thought leadership in this area by charging
the same amount per processor, regardless of how many cores are in the
processor. Microsoft was the first database vendor to make this
announcement, in October of 2004, and continues to be the only vendor to
date that has taken this position. This strategy is based on the belief
that multicore processors are a natural extension of Moore's Law (that
the number of transistors on a chip doubles about every one to two
years), and that the benefits should be passed on directly to customers.

For example, if you are using SQL Server Enterprise Edition on a
four-processor server with dual-core processors, using all eight cores
(two cores x four processors), you will require only four processor
licenses. That can mean substantial savings for customers of Microsoft
compared to its competitors.

Dual Core CPUs and SQL Server 2000

I need to configure and purchase two new servers running SQL 2000 Enterprise
Edition on Windows 2003 Enterprise Edition each equipped with 2 processors.
I'm wondering if anyone has experience with or knowledge of using dual core
Intel Xeon Processors with SQL Server, and if there are definite improvements
over single core higher clocked processors. I'm trying to decide whether to
configure the servers with two 2.8Ghz Dual Core Xeon processors or two 3.4Ghz
single core processors.
Thanks.
Hi
You may want to read this
http://www.sql-server-performance.com/jc_processor.asp although not
specifically about dual core I would expect dual core to be the akin to using
more than one processor.
John
"Marks70" wrote:

> I need to configure and purchase two new servers running SQL 2000 Enterprise
> Edition on Windows 2003 Enterprise Edition each equipped with 2 processors.
> I'm wondering if anyone has experience with or knowledge of using dual core
> Intel Xeon Processors with SQL Server, and if there are definite improvements
> over single core higher clocked processors. I'm trying to decide whether to
> configure the servers with two 2.8Ghz Dual Core Xeon processors or two 3.4Ghz
> single core processors.
> Thanks.

Dual Core CPUs and SQL Server 2000

I need to configure and purchase two new servers running SQL 2000 Enterprise
Edition on Windows 2003 Enterprise Edition each equipped with 2 processors.
I'm wondering if anyone has experience with or knowledge of using dual core
Intel Xeon Processors with SQL Server, and if there are definite improvements
over single core higher clocked processors. I'm trying to decide whether to
configure the servers with two 2.8Ghz Dual Core Xeon processors or two 3.4Ghz
single core processors.
Thanks.Hi
You may want to read this
http://www.sql-server-performance.com/jc_processor.asp although not
specifically about dual core I would expect dual core to be the akin to using
more than one processor.
John
"Marks70" wrote:
> I need to configure and purchase two new servers running SQL 2000 Enterprise
> Edition on Windows 2003 Enterprise Edition each equipped with 2 processors.
> I'm wondering if anyone has experience with or knowledge of using dual core
> Intel Xeon Processors with SQL Server, and if there are definite improvements
> over single core higher clocked processors. I'm trying to decide whether to
> configure the servers with two 2.8Ghz Dual Core Xeon processors or two 3.4Ghz
> single core processors.
> Thanks.

Dual Core CPUs and SQL Server 2000

I need to configure and purchase two new servers running SQL 2000 Enterprise
Edition on Windows 2003 Enterprise Edition each equipped with 2 processors.
I'm wondering if anyone has experience with or knowledge of using dual core
Intel Xeon Processors with SQL Server, and if there are definite improvement
s
over single core higher clocked processors. I'm trying to decide whether to
configure the servers with two 2.8Ghz Dual Core Xeon processors or two 3.4Gh
z
single core processors.
Thanks.Hi
You may want to read this
http://www.sql-server-performance.com/jc_processor.asp although not
specifically about dual core I would expect dual core to be the akin to usin
g
more than one processor.
John
"Marks70" wrote:

> I need to configure and purchase two new servers running SQL 2000 Enterpri
se
> Edition on Windows 2003 Enterprise Edition each equipped with 2 processors
.
> I'm wondering if anyone has experience with or knowledge of using dual cor
e
> Intel Xeon Processors with SQL Server, and if there are definite improveme
nts
> over single core higher clocked processors. I'm trying to decide whether t
o
> configure the servers with two 2.8Ghz Dual Core Xeon processors or two 3.4
Ghz
> single core processors.
> Thanks.

dtsx Fuzzly Grouping Package

I have SQL 2005 Developer edition and wanted to play with the Fuzzy Grouping featutre. I have created a package where I have a datareader source, fuzzy grouping, and SQL server destination. When I try to run this package I get the errors:
Error: The product level is insufficient for component "Datareader Source" [1]
Error: The product level is insufficient for component "Fuzzy grouping" [12]
Error: The product level is insufficient for component "SQL Server destination" [712]

I do get other warning before that about performance but these are the only errors. I increased the error level but that does not help, the above errors make the task fail.

What does it mean by "Product Level" and what am I doing wrong?

I can email code if necessary.

Thanks

DeanWhich release are you using?|||

When I do the help about I see:

MS visual studio 2005 version 8.0.50215.44
.Net framework version 2.0.50215
Microsoft SQL Server Analysis Services Designer
Microsoft SQL Server Analysis Services Designer
Version 9.00.1187.00

Microsoft SQL Server Integration Services Designer
Microsoft SQL Server Integration Services Designer
Version 9.00.1187.00

Microsoft SQL Server Report Designer
Microsoft SQL Server Report Designer
Version 9.00.1187.00

Microsoft SQL Server Report Model Designer
Microsoft SQL Server Report Model Designer
Version 9.00.1187.00
Does this help?

|||You're using developer edition right? Those components that are listed only work on Standard or Developer edition.

This link exlains what each edition contains: http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx

Actually it doesn't mention DataReader Source or SQL Server Destination but near the bottom you'll see clearly that fuzzy stuff is only in Enterprise Edition.

-Jamie|||Jamie,

Before I tackle the couple hours of uninstalling, downloading and reinstalling I just want to make sure that you are certain. On the page you specified it does not show the developer edition in the matrix and on this page http://www.microsoft.com/sql/2005/productinfo/ctp.mspx it specifically says that the developer edition includes all the functionality of the enterprise edition but is only licensed for developement and test systems. Also why would the controls and everything be in the developer edition if you could not use them. The error that I got makes me believe you may be right but all the documentation says differently.

Are you 100% positive?|||I'll be honest and say I was making an assumption based on the errors that you were getting. So 90% positive :)|||It sounds like you've got a configuration problem; all the components should work on the Developer Edition. What else do you have installed on that box? Have any other editions of SQL Server 2005 ever een installed on the machine? Have any verions of Visual Studio? (If so, did you install the edition of SQL Server that is selected by default during the Visual Studio installation?) Have you previously had other installations of SQL Server on the machine? What about SQL Server 2000?