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

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/...D52C-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:
> [url]http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-[/ur
l]
> 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:
> [url]http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-[/ur
l]
> 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

installing sp3?

I am using SQL 2000 Developers Edition with sp2
trying to install sp3a because it is a prereq for reporting services.
I installed sql2ksp3.exe. Everything seems to install fine and a messagebox
is
returned with a the "package has been installed succesful" message.
I restarted sql then ran the @.@. version query and still sp2
I restarted Window, then ran the query again with the same result
What my next step?
--
---
Yes, I searched first :)> I restarted sql then ran the @.@. version query and still sp2
AFAIK @.@.version gives you the SP of the OS, not of the SQL Server. What do
you get if you run
SELECT SERVERPROPERTY('ProductLevel')
?
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||SELECT SERVERPROPERTY('ProductLevel')
returns "sp2"
by the way:
@.@.version returns
sql 8.00.534 . thats not my OS.
"Dejan Sarka" wrote:
> > I restarted sql then ran the @.@. version query and still sp2
> AFAIK @.@.version gives you the SP of the OS, not of the SQL Server. What do
> you get if you run
> SELECT SERVERPROPERTY('ProductLevel')
> ?
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>|||It only installed the setup locally, now you need to run the setup. The
default setup install location is c:\sql2ksp3
Jeff
"Kmistic" <Kmistic@.discussions.microsoft.com> wrote in message
news:F4074DFD-0CA9-4843-82D5-969D431D2866@.microsoft.com...
> I am using SQL 2000 Developers Edition with sp2
> trying to install sp3a because it is a prereq for reporting services.
> I installed sql2ksp3.exe. Everything seems to install fine and a
messagebox
> is
> returned with a the "package has been installed succesful" message.
> I restarted sql then ran the @.@. version query and still sp2
> I restarted Window, then ran the query again with the same result
> What my next step?
> --
> ---
> Yes, I searched first :)|||ok, i see now. Thanks Jeff Dillon!!
"Jeff Dillon" wrote:
> It only installed the setup locally, now you need to run the setup. The
> default setup install location is c:\sql2ksp3
> Jeff
> "Kmistic" <Kmistic@.discussions.microsoft.com> wrote in message
> news:F4074DFD-0CA9-4843-82D5-969D431D2866@.microsoft.com...
> > I am using SQL 2000 Developers Edition with sp2
> >
> > trying to install sp3a because it is a prereq for reporting services.
> >
> > I installed sql2ksp3.exe. Everything seems to install fine and a
> messagebox
> > is
> > returned with a the "package has been installed succesful" message.
> >
> > I restarted sql then ran the @.@. version query and still sp2
> >
> > I restarted Window, then ran the query again with the same result
> >
> > What my next step?
> > --
> > ---
> > Yes, I searched first :)
>
>|||> by the way:
> @.@.version returns
> sql 8.00.534 . thats not my OS.
In your first post you did not mention version number, but you metioned
service pack explicitly, and @.@.version returns explicit service pack of the
OS.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

installing sp3?

I am using SQL 2000 Developers Edition with sp2
trying to install sp3a because it is a prereq for reporting services.
I installed sql2ksp3.exe. Everything seems to install fine and a messagebox
is
returned with a the "package has been installed succesful" message.
I restarted sql then ran the @.@. version query and still sp2
I restarted Window, then ran the query again with the same result
What my next step?
Yes, I searched first
> I restarted sql then ran the @.@. version query and still sp2
AFAIK @.@.version gives you the SP of the OS, not of the SQL Server. What do
you get if you run
SELECT SERVERPROPERTY('ProductLevel')
?
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
|||SELECT SERVERPROPERTY('ProductLevel')
returns "sp2"
by the way:
@.@.version returns
sql 8.00.534 . thats not my OS.
"Dejan Sarka" wrote:

> AFAIK @.@.version gives you the SP of the OS, not of the SQL Server. What do
> you get if you run
> SELECT SERVERPROPERTY('ProductLevel')
> ?
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>
|||It only installed the setup locally, now you need to run the setup. The
default setup install location is c:\sql2ksp3
Jeff
"Kmistic" <Kmistic@.discussions.microsoft.com> wrote in message
news:F4074DFD-0CA9-4843-82D5-969D431D2866@.microsoft.com...
> I am using SQL 2000 Developers Edition with sp2
> trying to install sp3a because it is a prereq for reporting services.
> I installed sql2ksp3.exe. Everything seems to install fine and a
messagebox
> is
> returned with a the "package has been installed succesful" message.
> I restarted sql then ran the @.@. version query and still sp2
> I restarted Window, then ran the query again with the same result
> What my next step?
> --
> Yes, I searched first
|||ok, i see now. Thanks Jeff Dillon!!
"Jeff Dillon" wrote:

> It only installed the setup locally, now you need to run the setup. The
> default setup install location is c:\sql2ksp3
> Jeff
> "Kmistic" <Kmistic@.discussions.microsoft.com> wrote in message
> news:F4074DFD-0CA9-4843-82D5-969D431D2866@.microsoft.com...
> messagebox
>
>
|||> by the way:
> @.@.version returns
> sql 8.00.534 . thats not my OS.
In your first post you did not mention version number, but you metioned
service pack explicitly, and @.@.version returns explicit service pack of the
OS.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com