Installing SQL Server Desktop Engine & Enterprise Manager

I downloaded and successfully installed SQL Server 2000 Desktop edition via
"MSDE2000A.exe".
Then, thinking I needed "sql2ksp3.exe" to install Enterprise Manager, I
attempted to install that.
But, I got an error message: "SQL Server 2000 is not installed on this
machine. Setup will now exit".
So, obviously the error message is wrong, as I did install SQL Server 2000.
So, don't know what to do.
One thing that may be affecting this is that when doing the S.S. 2000
install, I had to do it via a DOS window in order to set a flag for what's
called an "SA" password. And I was thinking that maybe that's affecting the
subsequent attempt to install Enterprise Manager?
I'm running WinXP Professional with SP2 on my PC.
A thought...since I really don't have SQL Server 2000 installed, but instead
the Desktop version, maybe "sql2ksp3.ext" is the wrong file?
Thanks.Hi,
Did you install MSDE SP3?
From the file name "sql2ksp3.exe", I think it's not the appropariate
release. The SP3 name for MSDE is sql2kdesksp3.exe.
You can download it from:
http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-
AFBF-ACACE5369FA3&displaylang=en
If you have any other questions or concerns, please feel free to let me
know.
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, a
nd confers no rights.
======================================================|||andyboy wrote on Thu, 3 Aug 2006 13:29:02 -0700:
> I downloaded and successfully installed SQL Server 2000 Desktop edition
> via "MSDE2000A.exe".
> Then, thinking I needed "sql2ksp3.exe" to install Enterprise Manager, I
> attempted to install that.
That's Service Pack 3 for SQL Server 2000. Enterprise Manager comes on the
SQL Server CD.
> But, I got an error message: "SQL Server 2000 is not installed on this
> machine. Setup will now exit".
> So, obviously the error message is wrong, as I did install SQL Server
> 2000. So, don't know what to do.
You installed SQL Server 2000 Desktop (MSDE). That is not the same as the
"proper" SQL Server (Standard and Enterprise).
> One thing that may be affecting this is that when doing the S.S. 2000
> install, I had to do it via a DOS window in order to set a flag for what's
> called an "SA" password. And I was thinking that maybe that's affecting
> the subsequent attempt to install Enterprise Manager?
> I'm running WinXP Professional with SP2 on my PC.
> A thought...since I really don't have SQL Server 2000 installed, but
> instead the Desktop version, maybe "sql2ksp3.ext" is the wrong file?
> Thanks.
If you want Enterprise Manager, you'll need to buy SQL Server. The
Desktop/MSDE version doesn't come with a GUI management tool. I'm not sure
if the SQL Server Express 2005 Management Studio GUI will work with Desktop
2000, if it does then you could use that.
Dan|||ok, thanks and 2 things:
1) the link you posted to get 'sql2kdesksp3.exe' isn't valid.
2) can I install Enterprise Manager with the desktop sql server?
"Charles Wang[MSFT]" wrote:
> Hi,
> Did you install MSDE SP3?
> From the file name "sql2ksp3.exe", I think it's not the appropariate
> release. The SP3 name for MSDE is sql2kdesksp3.exe.
> You can download it from:
> http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-
> AFBF-ACACE5369FA3&displaylang=en
> If you have any other questions or concerns, please feel free to let me
> know.
> Charles Wang
> Microsoft Online Community Support
> ======================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, a
> nd confers no rights.
> ======================================================>|||and I did successfully install sql server version 8.00.760.
so, is that the desktop version of sql server, or is it the 'full' version?
and if it's the full version, I'd prefer to leave it installed, I guess, and
then install Enterprise Manager for it.
so, how do I do that?
thanks.
"Charles Wang[MSFT]" wrote:
> Hi,
> Did you install MSDE SP3?
> From the file name "sql2ksp3.exe", I think it's not the appropariate
> release. The SP3 name for MSDE is sql2kdesksp3.exe.
> You can download it from:
> http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-
> AFBF-ACACE5369FA3&displaylang=en
> If you have any other questions or concerns, please feel free to let me
> know.
> Charles Wang
> Microsoft Online Community Support
> ======================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, a
> nd confers no rights.
> ======================================================>|||Hi,
Thanks for your post.
I tried the link again and can get access the web. The sql2kdesksp3.exe
package for downloading locates under the page below.
I recommend that you check wheter or not the url is devided into two lines.
If so, you need to combine the two lines into one line url.
You can install SQL Enterprise Mnager with MSDE2000, however, you need to
install it with named instance.
It's only allowed only one default instance installed on one server.
Sincerely yours,
Charles Wang
Microsoft Online Community Support|||Hi ,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Have a great day!
Charles Wang
Microsoft Online Community Support