473,657 Members | 2,499 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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.ex e (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.ex e 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 4682
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.1114 58$oR5.66769@pd 7tw3no...
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
4175
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, 2GB Ram, 3x36GB Hdd on Raid 5 Operating System: Redhat Linux 9 I will deploy only 1 database for the application. Only 1 DBA will use the Oracle server when necessary. When the database once deployed, Only 1
1
3369
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 Standard Edition server components is not supported on this operating system. Only client components will be
2
15217
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 Personal disk from the SQL Server 2000 Enterprise kit as this is reported here on the MSDN web site to be the version that is supported on Windows XP. In fact so many of you kind people confess to having succeeded in doing it. I have tried...
0
2648
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. I suspect that someone put the CD in the wrong sleeve, but I am not sure. Does the Personal Edition CD usually come in a sleeve with the CD key on it?
1
856
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: http://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=en ....it has these 3 files:
2
1484
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. After hitting the Finish & OK button it just wipes out the column settings. I've reinstalled both Personal & Developer edition. DTS will allow more than 125 prior to the service pack.
4
2543
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 missing and the snap-in fails to initiate. But then the Manager starts anyway. But the SQL application does not work. I searched around the net, and I found that it looks as if SQL Slammer has been on the server. I can tell by the similar...
4
1550
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 I can connect to my database anymore. The funny part is that if I connect to a full MS-SQL Server the program works just fine. Do I need to change anything in my connection string so I can connect to MSDE SP3a? Any Ideas of how I can solve this...
2
4444
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 help me from where can i get this Software package. Any URL or Company name who sells this Software. I want a original one with License No. And one more Query: Are Standard, Enterprise, Developer, Personal Edition are one & the same,
0
8310
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8827
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8605
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7333
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6167
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5632
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4158
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2731
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1957
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.