MSDE 2000 Release A - Query Analyzer included?

I installed MSDE 2000 Release A, but can't find the Query Analyzer. Is it
included, or only available with other SQL Server versions. If it is
included, then how do I install it? If not, can I download it from somewhere
else?
Hi
MSDE 2000 does not come with any of the tools like Query Analyzer or
Enterprise Manager.
You could download the evaluation edition of SQL Server 2000 and use those
tools for 120 days.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:41977C7A-205A-4CDA-AD56-843DF8779DE6@.microsoft.com...
>I installed MSDE 2000 Release A, but can't find the Query Analyzer. Is it
> included, or only available with other SQL Server versions. If it is
> included, then how do I install it? If not, can I download it from
> somewhere
> else?
>

MSDE 2000 Release A - Instalation Problem in Windows XP SP2

I can't install MSDE release A in Windows XP SP2. I verified if Server
Service is started and it is ok. I also verified if File and Printer sharing
is checked on network properties and it is ok. The windows firewall also is
disabled but the instalation doesn't work. I run the follow comand setup.exe
sapwd="suportebsb." /L*v C:/MSDELog.log.
Anyone can help me?
Regards,
Cicero Galdino
******** This is the lastest lines in log instalation files
*******************
2005-06-01 16:49:35.64 spid4 Default collation successfully changed.
2005-06-01 16:49:35.67 spid4 Recovery complete.
2005-06-01 16:49:35.67 spid4 SQL global counter collection task is
created.
2005-06-01 16:49:35.69 spid4 Warning: override, autoexec procedures
skipped.
2005-06-01 16:49:43.36 spid4 SQL Server is terminating due to 'stop'
request from Service Control Manager.
=== Logging stopped: 01/06/2005 16:59:54 ===
MSI (c) (18:48) [16:59:54:724]: Note: 1: 1708
MSI (c) (18:48) [16:59:54:724]: Product: Microsoft SQL Server Desktop Engine
-- Installation operation failed.
MSI (c) (18:48) [16:59:54:724]: Grabbed execution mutex.
MSI (c) (18:48) [16:59:54:724]: Cleaning up uninstalled install packages, if
any exist
MSI (c) (18:48) [16:59:54:740]: MainEngineThread is returning 1603
=== Verbose logging stopped: 01/06/2005 16:59:54 ===
hi Cicero,
Cicero wrote:
> I can't install MSDE release A in Windows XP SP2. I verified if Server
> Service is started and it is ok. I also verified if File and Printer
> sharing is checked on network properties and it is ok. The windows
> firewall also is disabled but the instalation doesn't work. I run the
> follow comand setup.exe sapwd="suportebsb." /L*v C:/MSDELog.log.
please inspect your C:/MSDELog.log for
RETURN VALUE 3
entrie(s), that reports exeptions duting the install process...
about 10/15 lines before each entry some (sometime cryptic) descritpion of
the problem will be available
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

msde 2000 install failes on xp

Hi
I cant install MSDE 2000 on one XP machine
Cant figure out whats wrong
Because log file too large
Download it here
www.deltmar.ee/logfile.zip
Regards;
Mex
hi Mex,
Meelis Lilbok wrote:
> Hi
> I cant install MSDE 2000 on one XP machine
> Cant figure out whats wrong
> Because log file too large
> Download it here
> www.deltmar.ee/logfile.zip
>
the relevant part of the log is
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
Action ended 14:59:46: InstallFinalize. Return value 3.
usually depending on re-intallation on partially cleaned machines..
please have a look at
http://support.microsoft.com/default...99&Product=sql
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE 2000 an 64 Bit CPU?

Does it make sense to use a 64 bit CPU with MSDE 2000? Or better: does MSDE
user it? I can′t find any hints.
hi,
Sven Behrend wrote:
> Does it make sense to use a 64 bit CPU with MSDE 2000? Or better:
> does MSDE user it? I cant find any hints.
actually it does not make sense... MSDE can use up to 2GB of ram, 2 CPUs and
a database size limit of 2GB (per database data file)... so having a 64bit
CPU in order to address more memory is non sense..
anyway, I never tried, but it should run in WOW on 64bit OS...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Ok, i′m talking about 100 Notebooks running MSDE as a SQL-platform for a CRM
system, so i would check it out befor changing, but the question is:
is MSDE using 64 bit or not?
"Andrea Montanari" wrote:

> hi,
> Sven Behrend wrote:
> actually it does not make sense... MSDE can use up to 2GB of ram, 2 CPUs and
> a database size limit of 2GB (per database data file)... so having a 64bit
> CPU in order to address more memory is non sense..
> anyway, I never tried, but it should run in WOW on 64bit OS...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi,
Sven Behrend wrote:
> Ok, im talking about 100 Notebooks running MSDE as a SQL-platform
> for a CRM system, so i would check it out befor changing, but the
> question is:
> is MSDE using 64 bit or not?
if the question is "can MSDE run on 64bit CPU" I do think yes, in Window On
Window...
if, on the contrary, the question is "using" it, MSDE is a 32 bit
application..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks, that′s it.
I have to make it faster, and that was an idea.
Sven Behrend
"Andrea Montanari" wrote:

> hi,
> Sven Behrend wrote:
> if the question is "can MSDE run on 64bit CPU" I do think yes, in Window On
> Window...
> if, on the contrary, the question is "using" it, MSDE is a 32 bit
> application..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>

MSDE 1 => msde 2 => MSDE 2 SP3a

I'm able to successfully upgrade my MSDE 1 installation from Office 2k to
MSDE 2, using any of the versions 1 thru 3a. However, I can't figure out
the command-line parameters to upgrade MSDE 2 to a newer version of MSDE 2,
at least not retaining my Office Server Extensions database. Considering
that SP 4 for MSDE 2 will probably be out soon, what's the proper method to
upgrade MSDE 2 when it was used to upgrade MSDE 1?
Well, I figured out the easy way to do things. First, you install MSDE 2.
Then you install office server extensions using the /nd switch to avoid
installing an older version of MSDE. Had a lot of registry cleaning to do,
had to unregister ows.dll, and a few other problems to fix before I could
get a successful install of OSE. Works fine, though. I was even able to
apply the OSE SP3 patch.
"Ellen Langton" <elangton@.wctc.net> wrote in message
news:emnXe$XCFHA.3688@.TK2MSFTNGP14.phx.gbl...
> I'm able to successfully upgrade my MSDE 1 installation from Office 2k to
> MSDE 2, using any of the versions 1 thru 3a. However, I can't figure out
> the command-line parameters to upgrade MSDE 2 to a newer version of MSDE
2,
> at least not retaining my Office Server Extensions database. Considering
> that SP 4 for MSDE 2 will probably be out soon, what's the proper method
to
> upgrade MSDE 2 when it was used to upgrade MSDE 1?
>
|||Well, I figured out the easy way to do things. First, you install MSDE 2.
Then you install office server extensions using the /nd switch to avoid
installing an older version of MSDE. Had a lot of registry cleaning to do,
had to unregister ows.dll, and a few other problems to fix before I could
get a successful install of OSE. Works fine, though. I was even able to
apply the OSE SP3 patch.
"Ellen Langton" <elangton@.wctc.net> wrote in message
news:emnXe$XCFHA.3688@.TK2MSFTNGP14.phx.gbl...
> I'm able to successfully upgrade my MSDE 1 installation from Office 2k to
> MSDE 2, using any of the versions 1 thru 3a. However, I can't figure out
> the command-line parameters to upgrade MSDE 2 to a newer version of MSDE
2,
> at least not retaining my Office Server Extensions database. Considering
> that SP 4 for MSDE 2 will probably be out soon, what's the proper method
to
> upgrade MSDE 2 when it was used to upgrade MSDE 1?
>

MSDE

Hi,
I can't uninstall MSDE from W2K server. Add/remove doesn't work.
It's any possibility to remove the engine?
Thanks
Marek
hi Marek,
Marek wrote:
> Hi,
> I can't uninstall MSDE from W2K server. Add/remove doesn't work.
> It's any possibility to remove the engine?
>
you can manually uninstall MSDE as described in
http://support.microsoft.com/default...;EN-US;Q290991 and/or
http://support.microsoft.com/default...en-us;320873..
the latter requires you to use MsiZap.exe, part of the Windows Installer
SDK, to clear up Windows Intaller related registry entries...
personally I always used the 1st one..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

msdb Single user

my msdb has been put into single user mode and i cant get it back to
multi_user can anyone help me with this
What put it in single user mode? Did you check the logs?
If it was a user action, did you try executing the
following:
ALTER DATABASE msdb
SET MULTI_USER
-Sue
On Tue, 30 Aug 2005 09:17:40 -0700, "A.B."
<AB@.discussions.microsoft.com> wrote:

>my msdb has been put into single user mode and i cant get it back to
>multi_user can anyone help me with this
|||I tried that but it said there was already a connection and could not alter
the database. I had to shutdown the SQL Server Agent in order to stop the
processes that are running in the background on that table. Then I could
execute the alter database statement.
"Sue Hoegemeier" wrote:

> What put it in single user mode? Did you check the logs?
> If it was a user action, did you try executing the
> following:
> ALTER DATABASE msdb
> SET MULTI_USER
> -Sue
> On Tue, 30 Aug 2005 09:17:40 -0700, "A.B."
> <AB@.discussions.microsoft.com> wrote:
>
>

msdb Single user

my msdb has been put into single user mode and i cant get it back to
multi_user can anyone help me with thisWhat put it in single user mode? Did you check the logs?
If it was a user action, did you try executing the
following:
ALTER DATABASE msdb
SET MULTI_USER
-Sue
On Tue, 30 Aug 2005 09:17:40 -0700, "A.B."
<AB@.discussions.microsoft.com> wrote:
>my msdb has been put into single user mode and i cant get it back to
>multi_user can anyone help me with this|||I tried that but it said there was already a connection and could not alter
the database. I had to shutdown the SQL Server Agent in order to stop the
processes that are running in the background on that table. Then I could
execute the alter database statement.
"Sue Hoegemeier" wrote:
> What put it in single user mode? Did you check the logs?
> If it was a user action, did you try executing the
> following:
> ALTER DATABASE msdb
> SET MULTI_USER
> -Sue
> On Tue, 30 Aug 2005 09:17:40 -0700, "A.B."
> <AB@.discussions.microsoft.com> wrote:
> >my msdb has been put into single user mode and i cant get it back to
> >multi_user can anyone help me with this
>

msdb Single user

my msdb has been put into single user mode and i cant get it back to
multi_user can anyone help me with thisWhat put it in single user mode? Did you check the logs?
If it was a user action, did you try executing the
following:
ALTER DATABASE msdb
SET MULTI_USER
-Sue
On Tue, 30 Aug 2005 09:17:40 -0700, "A.B."
<AB@.discussions.microsoft.com> wrote:

>my msdb has been put into single user mode and i cant get it back to
>multi_user can anyone help me with this|||I tried that but it said there was already a connection and could not alter
the database. I had to shutdown the SQL Server Agent in order to stop the
processes that are running in the background on that table. Then I could
execute the alter database statement.
"Sue Hoegemeier" wrote:

> What put it in single user mode? Did you check the logs?
> If it was a user action, did you try executing the
> following:
> ALTER DATABASE msdb
> SET MULTI_USER
> -Sue
> On Tue, 30 Aug 2005 09:17:40 -0700, "A.B."
> <AB@.discussions.microsoft.com> wrote:
>
>