Re: Is SQL server not installed with VS2005

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"The developer edition of SQL Server" does not refer to a particular
version. I mean, when was this developer edition released? Could be any
time, since there is no version number tied to it. Microsoft always refers
to it with the version number.

If you ask someone who has this installed on their machine, every single one
will tell you they have SQL Server 2000 running on their machine. I know
this, because this is what developers answer me, and what I answer
developers. Because in fact, it is the fact that it is the 2000 edition
that people care about. The fact that it happens to be the developer
edition is actually irrelevant to developers, as they just want to have a
local database to run against. Developers just don't care whether or not
they have the full fledged SQL Server installed.

But they do care if it's 2000 vs 2005, vs another older version, as that
actually has an impact as to how they write their code.

Lastly, if you do "select @@version", you get:

Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)

Notice that MS considers this 'Microsoft SQL Server 2000", and mention this
in the name.


"Juan T. Llibre" <nomailreplies@xxxxxxxxxxx> wrote in message
news:eOex8O0BHHA.1224@xxxxxxxxxxxxxxxxxxxxxxx
re:
and referred to as 'SQL Server 2000'. Otherwise, what would you call
it - the developer edition of what?

The "developer edition" of "SQL Server", of course.

"SQL Server 2000" is a product.
"SQL Server 2000 Developer Edition" is a different product.

You should call each product by its (proper) name.

re:
Just like there are different editions of Visual Studio .NET - and they
all have different capabilities, but they are all still Visual Studio
.NET. Just different editions of it.

I would *never* call any of the Express Editions "Visual Studio 2005".
The proper way to refer to the Express editions is to include the
"Express" moniker.

The same for SQL Server and its editions.




Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================
"Marina Levit [MVP]" <someone@xxxxxxxxxx> wrote in message
news:ucIXBozBHHA.4908@xxxxxxxxxxxxxxxxxxxxxxx
No, it is not incorrect.

Just because it is the developer edition, doesn't mean it's not SQL
Server 2000. It just means it is SQL Server 2000 developer edition. And
yes, different editions may have different capabilities, but it is still
called and referred to as 'SQL Server 2000'. Otherwise, what would you
call it - the developer edition of what? The product has to have a name,
and that name is 'SQL Server 2000'.

Just like there are different editions of Visual Studio .NET - and they
all have different capabilities, but they are all still Visual Studio
.NET. Just different editions of it.

"Juan T. Llibre" <nomailreplies@xxxxxxxxxxx> wrote in message
news:eR8aKmzBHHA.3396@xxxxxxxxxxxxxxxxxxxxxxx
Incorrect.

http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx

SQL Server 2000 Enterprise Edition and Standard Edition can run on the
following operating systems:

Windows Server 2003 R2
Windows Server 2003, Standard Edition1
Windows Server 2003, Enterprise Edition2
Windows Server 2003, Datacenter Edition3
Windows® 2000 Server
Windows 2000 Advanced Server
Windows 2000 Datacenter Server

SQL Server 2000 Evaluation Edition and Developer Edition
and Workgroup Edition can run on the following operating systems:

Operating systems listed above for Enterprise and Standard Editions
Windows XP Professional
Windows XP Home Edition
Windows 2000 Professional

SQL Server 2000 Personal Edition and SQL Server 2000
Desktop Engine (MSDE) can run on the following operating systems:

Operating systems listed above for Enterprise, Standard, Evaluation, and
Developer Editions
Windows Server 2003, Web Edition5 (MSDE only)
Windows 98
Windows Millennium Edition (Windows Me)

If you are running Windows XP, you are running either the Developer
Edition
or the Workgroup Edition or the Personal Edition.

Let me repeat :
You *cannot* run SQL Server 2000 Enterprise Edition nor the Standard
Edition on XP.

*Those* are what the name "SQL Server 2000" refers to.
The Developer, Workgroup, and Personal editions *cannot* do what SQL
Server 2000 Server does.



Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================
"Marina Levit [MVP]" <someone@xxxxxxxxxx> wrote in message
news:OwhfLAzBHHA.2328@xxxxxxxxxxxxxxxxxxxxxxx
I have SQL Server 2000 running right now on my Windows XP Pro machine,
and have had it for several years.

"Juan T. Llibre" <nomailreplies@xxxxxxxxxxx> wrote in message
news:ez3elGyBHHA.3536@xxxxxxxxxxxxxxxxxxxxxxx
You can't install SQL Server 2000 on Windows XP.
You *can* install MSDE 2000 or SQL Server 2005 Express.

http://www.microsoft.com/sql/prodinfo/previousversions/msde/prodinfo.mspx

http://msdn.microsoft.com/vstudio/express/sql/register/default.aspx



Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================
"Developer" <groups.4.aspdotnet@xxxxxxxxx> wrote in message
news:1163418549.904919.150550@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello All,
i have recently installed VS2005 and was trying to install SQL sever
2000.
I have Win XP' SP2. But when I tried installing, it only installed
client tools and not the database.
Can anyone please help me with this as I want to install SQL server
and
also wouold be grateful, if you can suggest me any workaround to
dealwith this problem.(Like should I install any new OS etc).

Any help would be appreciated.

Thanks and Regards,
Deo













.

Relevant Pages

  • Install of MSDE on XP Pro Failed, HELP Please ANYONE!!!
    ... I have for the past 1.5 weeks been trying to get MSDE installed on a Windows ... We formatted and install only SP2 on ... SOFTWARE\Microsoft\Microsoft SQL Server ... Starting custom action InstallPerfMon ...
    (microsoft.public.sqlserver.msde)
  • Re: right cab to use
    ... i try to install the right cab for: ... Is it Windows Mobile 5 or Windows CE 5? ... Manually copy and extract the .cab files. ... The Sqlce.dev.platform.processor.cab file includes SQL Server CE Query ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Problem of MSDE 2000 Release A Installation
    ... > System Prompt msg "pls go to control panel to install &configure your sys ... >> talk to SQL Server. ... >> Authentication, the new default, lets anyone with a Windows login talk to ...
    (microsoft.public.sqlserver.msde)
  • Re: unable to install SQL Express 2005 CTP
    ... > Am trying to install SQL Server Express CTP on my machine (Windows XP ...
    (microsoft.public.dotnet.general)
  • Re: How to uninstall an incomplete Hotfix?
    ... The forum for SQL Server 2008 ... Windows Update then requested I install "Hotfix for .NET Framework ...
    (microsoft.public.windowsupdate)