473,395 Members | 1,679 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Which SP3a for SQL 2000 Personal Edition?

Hi folks,

I need to know which EXE's of SP3 to install with SQL Server 2000 Personal
Edition. From the Microsoft website:
http://www.microsoft.com/downloads/d...displaylang=en

....it has these 3 files:

Database Components
Downloadable file name: SQL2KSP3.exe (56453 KB)
Updates for the database components of SQL Server 2000 include: Data
engine. Database
client utilities, such as SQL Server Enterprise Manager and osql for
SQL Server 2000. Database
client connectivity components, such as the OLE DB Provider for SQL
Server, the SQL Server
Open Database Connectivity (ODBC) driver, and the client
Net-Libraries.

Analysis Services Components
Downloadable file name: SQL2KASP3.exe (44617 KB)
Updates for the Analysis Services components of SQL Server 2000
include: Analysis Services
engine. Analysis Services client components, such as Analysis
Manager and the OLE DB Provider
for Analysis Services. Database client connectivity components, such
as the OLE DB Provider for
SQL Server, the SQL Server ODBC driver, and the client
Net-Libraries.

SQL Server 2000 Desktop Engine(MSDE)
Downloadable file name: SQL2kdesksp3.exe (70815 KB)
SP3a updates for MSDE include updates and new installations for the
database components of instances
of the SQL Server 2000 Desktop Engine, including: The Desktop data
engine. Database client connectivity
components, such as the OLE DB Provider for SQL Server, the SQL
Server ODBC driver, and the client
Net-Libraries. SQL2kdesksp3.exe includes all of the files that are
required to install a new instance of
Desktop Engine (.msi files), to upgrade all existing instances of
Desktop Engine (.msp files), as well as
to consume merge modules (.msm files) into applications. You can
install the three parts of SP3a
described above individually. However, if you want to upgrade both
your database components and
Analysis Services components, you must apply both the SP3a database
components and the SP3a
Analysis Services components.

Which one(s) do I need to install for Personal Edition? This is important,
because we need to build an install CD for the office, and space is limited
(due to other files).

Can anyone help?

Greg
Jul 20 '05 #1
1 4656
The first one (SQL2KSP3.exe). The second one is for Analysis Services, and
the third is for MSDE.

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

"gregs" <jo**@smith.com> wrote in message
news:Sf2fc.111458$oR5.66769@pd7tw3no...
Hi folks,

I need to know which EXE's of SP3 to install with SQL Server 2000 Personal
Edition. From the Microsoft website:

Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Murtix Van Basten | last post by:
Hi all, I will deploy a database project to an Oracle server, but I could not figure out which version of Oracle should I get. Here is my configuration: Hardware: Dell 1750 Dual Xeon 3.2Ghz,...
1
by: Thomas | last post by:
Hello, I received the error message below when i'm trying to install SQL Server 2000 standard edition into a Windows 2000 Professionale workstation. Error : Microsoft SQL server 2000...
2
by: Ken Lindner | last post by:
I have a need to become familiar with SQL Server 2000 for work. Needless to say I am new to SQL Server any version, but not IT in general. My employer has provided me with the SQL Server 2000...
0
by: Bill S. | last post by:
We have a Sql Server 2000 Personal Edition CD that came with a system we bought with SQL Server Standard Edition and other application software. The CD sleeve does not have a CD key on the back....
1
by: gregs | last post by:
Hi folks, I need to know which EXE's of SP3 to install with SQL Server 2000 Personal Edition. From the Microsoft website: ...
2
by: shinobi332 | last post by:
I have a DTS package that is importing a fixed length file. After installing SP3a (on PERSONAL & DEVELOPER edition) it will not allow me to assign more than 125 fixed length column positions....
4
by: Lars Bonnesen | last post by:
A Win2k, SQL2k machine with SP2 that only just now has been updated to SP3a fails in different ways. Among other things, when I now start Enterprise Manager, I get a message saying "rebbrui.rll" is...
4
by: Jesus Carmona | last post by:
Good day everyone; I'm having a program for a PocketPC that was working great, this program connects to a database (MSDE) but when I updated the MSDE to SP3a everything blew-up... There is no way...
2
by: sohail28 | last post by:
Hello, I want to Buy "SQL Server 2000 Personal Edition", from online or reseller etc., I fed up of searching for SQL Server 2000 Personal Edition, in online & in Software Market. Any one can...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.