MSDE 2000 Wont Install after Uninstall

I installed MSDE 2000, then uninstalled it because of a
problem with a 3rd party program. I then uninstalled that
3rd party program and downloaded sql2kdesksp3.exe, and
unpacked the installer. I ran a command prompt and typed
setup SAPWD=password SecurityType=SQL
and it began to install, but when the installer came down 5
seconds it would just pause and not do anything. There is
no harddrive activity or anything. I have redownloaded the
package, and tried many things to try and get it to
working, but no success.
Help!
hi Mike,
"Mike" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:069c01c4b60c$09261510$a601280a@.phx.gbl
> I installed MSDE 2000, then uninstalled it because of a
> problem with a 3rd party program. I then uninstalled that
> 3rd party program and downloaded sql2kdesksp3.exe, and
> unpacked the installer. I ran a command prompt and typed
> setup SAPWD=password SecurityType=SQL
> and it began to install, but when the installer came down 5
> seconds it would just pause and not do anything. There is
> no harddrive activity or anything. I have redownloaded the
> package, and tried many things to try and get it to
> working, but no success.
first of all, you have to specify SECURITYMODE=SQL and not SecurityType=SQL
the problem you are facing is probably related to "Setup failed to configure
the server", as explained in
http://support.microsoft.com/default...99&Product=sql
due to a incomplete removal of MSDE instance... anyway, try adding the
/L*v "c:\MsdeLog.txt"
parameter to you command line call to setup.exe in order to create a (about
2mb) verbose log of the installation process, where you can search for
RETURN VALUE 3
condition and, about 10 lines before or after the failure cause is (little)
explained
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE 2000 SP4 Merge Modules

I have a MSDE 2000 InstallShield install package that I've created using the
merge modules. I downloaded the SP4 of the desktop engine from the microsoft
site. When downloaded and extracted, there is a folder on my machine
\MSDE\MSM which has all of the merge modules. I've noticed that the SP4
release has 3 new mm's: msxmlsql32.msm, msxmlsqlr32.msm, and qfepatch.msm.
In the InstallShield DevStudio 9.01 IDE, I check the 3 new mm's. When I go
and build I receive the following error: "Error retrieving dependency
MSXMLSQL1033.996A3FBA_B9BC_4189_9DB1_2B3C86B526BC: 1033 of C:\Program
Files\InstallShield\DevStudio 9\Modules\i386\MSXMLSQL32.MSM". Anyone know
why I'm getting this error?
Thanks.
Joanne
hi Joanne
jbayog wrote:
> I have a MSDE 2000 InstallShield install package that I've created
> using the merge modules. I downloaded the SP4 of the desktop engine
> from the microsoft site. When downloaded and extracted, there is a
> folder on my machine \MSDE\MSM which has all of the merge modules.
> I've noticed that the SP4 release has 3 new mm's: msxmlsql32.msm,
> msxmlsqlr32.msm, and qfepatch.msm. In the InstallShield DevStudio
> 9.01 IDE, I check the 3 new mm's. When I go and build I receive the
> following error: "Error retrieving dependency
> MSXMLSQL1033.996A3FBA_B9BC_4189_9DB1_2B3C86B526BC: 1033 of C:\Program
> Files\InstallShield\DevStudio 9\Modules\i386\MSXMLSQL32.MSM". Anyone
> know why I'm getting this error?
no idea, never used MSDE merge modules, always installed using the setup.exe
boostrap installer.... but have you tried modifying the order of
installation?
http://msdn.microsoft.com/library/de...stsql_8yeq.asp
has not been updated (as BOL in general) at sp4 level, so no additional info
about those new merge modules seems available..
BTW, the MSDE readme file, at point 4.2 MSDE 2000 SP4 File location
specifies:
"Note Merge modules are not supported for new installations. They are
provided in SP4 for servicing instances of MSDE 2000 that were previously
installed using merge modules."
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I don't know much about MSDE and am just doing some research on it as of
this week.
However, I cam across this link yesterday which might be useful:
http://www.microsoft.com/sql/downloads/2000/sp4.asp
Here is an extract from the site:
"Users who have an existing instance of MSDE 2000 must know how their
instance of MSDE 2000 was installed to know how to update it. In particular,
you must know the original package name for your instance of MSDE 2000. To
determine the original package name, see the article How To Identify Which
MSI File Was Used for an Existing MSDE Installation in the Microsoft
Knowledge Base."
"jbayog" <jbayog@.discussions.microsoft.com> wrote in message
news:8D058312-1747-4A51-A100-FE79DC32C086@.microsoft.com...
>I have a MSDE 2000 InstallShield install package that I've created using
>the
> merge modules. I downloaded the SP4 of the desktop engine from the
> microsoft
> site. When downloaded and extracted, there is a folder on my machine
> \MSDE\MSM which has all of the merge modules. I've noticed that the SP4
> release has 3 new mm's: msxmlsql32.msm, msxmlsqlr32.msm, and
> qfepatch.msm.
> In the InstallShield DevStudio 9.01 IDE, I check the 3 new mm's. When I
> go
> and build I receive the following error: "Error retrieving dependency
> MSXMLSQL1033.996A3FBA_B9BC_4189_9DB1_2B3C86B526BC: 1033 of C:\Program
> Files\InstallShield\DevStudio 9\Modules\i386\MSXMLSQL32.MSM". Anyone know
> why I'm getting this error?
> Thanks.
> Joanne
|||Thanks so much for your help. This an existing MSDE 2000 InstallShield
install package and we have a client who wants to upgrade to SP4 so that is
why I'm trying to build an upgrade for them. I'd like to get rid of using
the MSDE 2000 merge modules per Microsoft's comment. I got it to build by
editing the msxmlsql32.msm and the msxmlsqlr32.msm using the Orca tool. I
think there is a problem with the rows in the ModuleDependency table. I
guess I have the option of building it without these two mm's as our database
application doesn't use xml. I'm a little apprehensive of doing this only
because there is no documentation on these new mm's. I might post to
InstallShield also. Again thanks.
Joanne
Joanne
"Andrea Montanari" wrote:

> hi Joanne
> jbayog wrote:
> no idea, never used MSDE merge modules, always installed using the setup.exe
> boostrap installer.... but have you tried modifying the order of
> installation?
> http://msdn.microsoft.com/library/de...stsql_8yeq.asp
> has not been updated (as BOL in general) at sp4 level, so no additional info
> about those new merge modules seems available..
> BTW, the MSDE readme file, at point 4.2 MSDE 2000 SP4 File location
> specifies:
> "Note Merge modules are not supported for new installations. They are
> provided in SP4 for servicing instances of MSDE 2000 that were previously
> installed using merge modules."
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.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 Installation

I am new to MSDE. Not MS-SQL server was installed in this desktop before. I have downloaded MSDERelA and installed it using the command line prompt. I can not the see the SQLServer programs under Start/Programs menu. What am I doing wrong? Should I be
installing a different program instead of MSDE2000RelA? Please help. Thank you.
MSDE doesn't have a graphical user interface and it doesn't create any menu
items in the Start/Programs menu. You can check if MSDE is installed by
looking in Control Panel|Add/Remove Programs.
Jacco Schalkwijk
SQL Server MVP
"Sukhendu Barua" <anonymous@.discussions.microsoft.com> wrote in message
news:EFAACD33-0C01-426B-8D83-A32F061F9C82@.microsoft.com...
> I am new to MSDE. Not MS-SQL server was installed in this desktop before.
I have downloaded MSDERelA and installed it using the command line prompt.
I can not the see the SQLServer programs under Start/Programs menu. What am
I doing wrong? Should I be installing a different program instead of
MSDE2000RelA? Please help. Thank you.
|||Thanks Jacco,
I checked as you suggested and saw that MSDE is installed. Where would I find the free version of graphical user interface that will work with MSDE? Do I need to remove MSDE to install the GUI?
-- Jacco Schalkwijk wrote: --
MSDE doesn't have a graphical user interface and it doesn't create any menu
items in the Start/Programs menu. You can check if MSDE is installed by
looking in Control Panel|Add/Remove Programs.
Jacco Schalkwijk
SQL Server MVP
"Sukhendu Barua" <anonymous@.discussions.microsoft.com> wrote in message
news:EFAACD33-0C01-426B-8D83-A32F061F9C82@.microsoft.com...
> I am new to MSDE. Not MS-SQL server was installed in this desktop before.
I have downloaded MSDERelA and installed it using the command line prompt.
I can not the see the SQLServer programs under Start/Programs menu. What am
I doing wrong? Should I be installing a different program instead of
MSDE2000RelA? Please help. Thank you.
|||You don't need to remove MSDE to install the GUI. You can download a web
based GUI from Microsoft, www.microsoft.com/sql look for the SQL Server Web
Data Administrator. There are also a host of free tools available from other
source, just try Google.
Jacco Schalkwijk
SQL Server MVP
"Sukhendu Barua" <anonymous@.discussions.microsoft.com> wrote in message
news:19A5FEAA-E692-4273-A5E1-586B95F5C03F@.microsoft.com...
> Thanks Jacco,
> I checked as you suggested and saw that MSDE is installed. Where would I
find the free version of graphical user interface that will work with MSDE?
Do I need to remove MSDE to install the GUI?
> -- Jacco Schalkwijk wrote: --
> MSDE doesn't have a graphical user interface and it doesn't create
any menu
> items in the Start/Programs menu. You can check if MSDE is installed
by
> looking in Control Panel|Add/Remove Programs.
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Sukhendu Barua" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
> news:EFAACD33-0C01-426B-8D83-A32F061F9C82@.microsoft.com...
before.
> I have downloaded MSDERelA and installed it using the command line
prompt.
> I can not the see the SQLServer programs under Start/Programs menu.
What am
> I doing wrong? Should I be installing a different program instead of
> MSDE2000RelA? Please help. Thank you.
>
>
|||hi,
"Sukhendu Barua" <anonymous@.discussions.microsoft.com> ha scritto nel
messaggio news:19A5FEAA-E692-4273-A5E1-586B95F5C03F@.microsoft.com...
> Thanks Jacco,
> I checked as you suggested and saw that MSDE is installed. Where would I
find the free version of
>graphical user interface that will work with MSDE? Do I need to remove
MSDE to install the GUI?
as Jacco already pointed out, you can have a look at
http://www.microsoft.com/sql/msde/partners/default.asp and or
http://www.aspfaq.com/show.asp?id=2442 for additional third parties tools..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Jacco,
I installed the SQL Server Web Data Administrator. The installation never asked for my userid and password. When try to login what userid/pw should I be using?. I tried my windows login and pw and it did not work. Then i tried sa as userid and AStrong
SAPwd as password, did not work it either. I tried both windows authenticate mode and sql mode. The server is (local).
-- Jacco Schalkwijk wrote: --
You don't need to remove MSDE to install the GUI. You can download a web
based GUI from Microsoft, www.microsoft.com/sql look for the SQL Server Web
Data Administrator. There are also a host of free tools available from other
source, just try Google.
Jacco Schalkwijk
SQL Server MVP
"Sukhendu Barua" <anonymous@.discussions.microsoft.com> wrote in message
news:19A5FEAA-E692-4273-A5E1-586B95F5C03F@.microsoft.com...
> Thanks Jacco,
> I checked as you suggested and saw that MSDE is installed. Where would I
find the free version of graphical user interface that will work with MSDE?
Do I need to remove MSDE to install the GUI?[vbcol=seagreen]
any menu
> items in the Start/Programs menu. You can check if MSDE is installed
by[vbcol=seagreen]
> looking in Control Panel|Add/Remove Programs.
> Jacco Schalkwijk
> SQL Server MVP
message[vbcol=seagreen]
> news:EFAACD33-0C01-426B-8D83-A32F061F9C82@.microsoft.com...
before.
> I have downloaded MSDERelA and installed it using the command line
prompt.
> I can not the see the SQLServer programs under Start/Programs menu.
What am[vbcol=seagreen]
> I doing wrong? Should I be installing a different program instead of
> MSDE2000RelA? Please help. Thank you.
|||Thank you Andrea. DbaMgr2k works great!
Cheers,
Sukhendu
-- Andrea Montanari wrote: --
hi,
"Sukhendu Barua" <anonymous@.discussions.microsoft.com> ha scritto nel
messaggio news:19A5FEAA-E692-4273-A5E1-586B95F5C03F@.microsoft.com...
> Thanks Jacco,
> I checked as you suggested and saw that MSDE is installed. Where would I
find the free version of
>graphical user interface that will work with MSDE? Do I need to remove
MSDE to install the GUI?
as Jacco already pointed out, you can have a look at
http://www.microsoft.com/sql/msde/partners/default.asp and or
http://www.aspfaq.com/show.asp?id=2442 for additional third parties tools..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

MSDE 2000 help please

Hi,
I downloaded MSDE 2000 but it's my first time using it and I dont know what
i'm doing. I'm using coldfusion for database driven websites. I can make
databases by using osql in a command prompt but is there an easier way? also
where does the server save the databases that i create? I cant find anything
on my system after i created a basic db.
Any help would be appreciated,
Thanks> I can make
> databases by using osql in a command prompt but is there an easier way?
http://www.aspfaq.com/2442

> also where does the server save the databases that i create?
The data and objects are stored in MDF files on your hard drive. They don't
really have any meaning independently (e.g. you can't open them in notepad
or Excel and look at them like you would in Access or other desktop
applications).

> I cant find anything
> on my system after i created a basic db.
Well, what did you do to "create a basic db"? What are you looking for on
your system?
A|||> Well, what did you do to "create a basic db"? What are you looking for on
> your system?
to start i did osql -E in a command prompt, then I did CREATE DATABASE
Study. Now I cant find the database in my hard drive. I'm "looking" for it s
o
i can use it in coldfusion server. I need to point to a physical file to
register that db so I can manipulate it in my web pages.The documentation on
how to do such things arent very available on the ms knowledge base. At leas
t
IMO
Phil|||It does not work this way. You can't point an application at a data file
for SQL Server and expect to "manipulate it in your web pages."
However, go ahead, look for the file, it will be called study_data.mdf, most
likely.
Let us know when you run out of ideas trying to point ColdFusion at that
file and banging your head against the wall.
You might consider checking ColdFusion documentation; there's plenty of
information available about SQL Server and MSDE in the knowledge base
(perhaps you just aren't sure what to look for).
http://www.aspfaq.com/
(Reverse address to reply.)
"Skinman" <Skinman@.discussions.microsoft.com> wrote in message
news:730E0313-4155-47E0-A309-B43AB5A10660@.microsoft.com...
on[vbcol=seagreen]
> to start i did osql -E in a command prompt, then I did CREATE DATABASE
> Study. Now I cant find the database in my hard drive. I'm "looking" for it
so
> i can use it in coldfusion server. I need to point to a physical file to
> register that db so I can manipulate it in my web pages.The documentation
on
> how to do such things arent very available on the ms knowledge base. At
least
> IMO
> Phil

MSDE 2000 help please

Hi,
I downloaded MSDE 2000 but it's my first time using it and I dont know what
i'm doing. I'm using coldfusion for database driven websites. I can make
databases by using osql in a command prompt but is there an easier way? also
where does the server save the databases that i create? I cant find anything
on my system after i created a basic db.
Any help would be appreciated,
Thanks
> I can make
> databases by using osql in a command prompt but is there an easier way?
http://www.aspfaq.com/2442

> also where does the server save the databases that i create?
The data and objects are stored in MDF files on your hard drive. They don't
really have any meaning independently (e.g. you can't open them in notepad
or Excel and look at them like you would in Access or other desktop
applications).

> I cant find anything
> on my system after i created a basic db.
Well, what did you do to "create a basic db"? What are you looking for on
your system?
A
|||> Well, what did you do to "create a basic db"? What are you looking for on
> your system?
to start i did osql -E in a command prompt, then I did CREATE DATABASE
Study. Now I cant find the database in my hard drive. I'm "looking" for it so
i can use it in coldfusion server. I need to point to a physical file to
register that db so I can manipulate it in my web pages.The documentation on
how to do such things arent very available on the ms knowledge base. At least
IMO
Phil
|||It does not work this way. You can't point an application at a data file
for SQL Server and expect to "manipulate it in your web pages."
However, go ahead, look for the file, it will be called study_data.mdf, most
likely.
Let us know when you run out of ideas trying to point ColdFusion at that
file and banging your head against the wall.
You might consider checking ColdFusion documentation; there's plenty of
information available about SQL Server and MSDE in the knowledge base
(perhaps you just aren't sure what to look for).
http://www.aspfaq.com/
(Reverse address to reply.)
"Skinman" <Skinman@.discussions.microsoft.com> wrote in message
news:730E0313-4155-47E0-A309-B43AB5A10660@.microsoft.com...[vbcol=seagreen]
on
> to start i did osql -E in a command prompt, then I did CREATE DATABASE
> Study. Now I cant find the database in my hard drive. I'm "looking" for it
so
> i can use it in coldfusion server. I need to point to a physical file to
> register that db so I can manipulate it in my web pages.The documentation
on
> how to do such things arent very available on the ms knowledge base. At
least
> IMO
> Phil

MSDE 2000 help please

Hi,
I downloaded MSDE 2000 but it's my first time using it and I dont know what
i'm doing. I'm using coldfusion for database driven websites. I can make
databases by using osql in a command prompt but is there an easier way? also
where does the server save the databases that i create? I cant find anything
on my system after i created a basic db.
Any help would be appreciated,
Thanks> I can make
> databases by using osql in a command prompt but is there an easier way?
http://www.aspfaq.com/2442
> also where does the server save the databases that i create?
The data and objects are stored in MDF files on your hard drive. They don't
really have any meaning independently (e.g. you can't open them in notepad
or Excel and look at them like you would in Access or other desktop
applications).
> I cant find anything
> on my system after i created a basic db.
Well, what did you do to "create a basic db"? What are you looking for on
your system?
A|||> Well, what did you do to "create a basic db"? What are you looking for on
> your system?
to start i did osql -E in a command prompt, then I did CREATE DATABASE
Study. Now I cant find the database in my hard drive. I'm "looking" for it so
i can use it in coldfusion server. I need to point to a physical file to
register that db so I can manipulate it in my web pages.The documentation on
how to do such things arent very available on the ms knowledge base. At least
IMO
Phil|||It does not work this way. You can't point an application at a data file
for SQL Server and expect to "manipulate it in your web pages."
However, go ahead, look for the file, it will be called study_data.mdf, most
likely.
Let us know when you run out of ideas trying to point ColdFusion at that
file and banging your head against the wall.
You might consider checking ColdFusion documentation; there's plenty of
information available about SQL Server and MSDE in the knowledge base
(perhaps you just aren't sure what to look for).
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Skinman" <Skinman@.discussions.microsoft.com> wrote in message
news:730E0313-4155-47E0-A309-B43AB5A10660@.microsoft.com...
> > Well, what did you do to "create a basic db"? What are you looking for
on
> > your system?
> to start i did osql -E in a command prompt, then I did CREATE DATABASE
> Study. Now I cant find the database in my hard drive. I'm "looking" for it
so
> i can use it in coldfusion server. I need to point to a physical file to
> register that db so I can manipulate it in my web pages.The documentation
on
> how to do such things arent very available on the ms knowledge base. At
least
> IMO
> Phil

MSDE 2000 Downloaded and Installed But where is Enterprise Manager

Dear Experts,
I have downloaded MSDE 2000RelA and i installed it. But where is the
Enterprise Manager and Query Analyzer a-la SQL Server 7.0? Any help would be
greatly appreciated
Thanks
Manish
Three Cheers to Technet for the Help!
Hi,
MSDE will not come with Enterprise manager or Query analyser. You have to
use the command prompt utilizty OSQL to execute all
the TSQL commands. See the details of OSQL utility in books online.
You could also download and use the WEB data ADMIN free tool from microsoft
site.
http://www.microsoft.com/downloads/d...displaylang=en
Thanks
Hari
SQL Server MVP
"Manish Sawjiani" <ManishSawjiani@.discussions.microsoft.com> wrote in
message news:42FB064A-B6B7-4F20-A3D4-C437096682E1@.microsoft.com...
> Dear Experts,
> I have downloaded MSDE 2000RelA and i installed it. But where is the
> Enterprise Manager and Query Analyzer a-la SQL Server 7.0? Any help would
> be
> greatly appreciated
> Thanks
> Manish
> --
> Three Cheers to Technet for the Help!

MSDE 2000 Downloaded and Installed But where is Enterprise Manager

Dear Experts,
I have downloaded MSDE 2000RelA and i installed it. But where is the
Enterprise Manager and Query Analyzer a-la SQL Server 7.0? Any help would be
greatly appreciated
Thanks
Manish
--
Three Cheers to Technet for the Help!Hi,
MSDE will not come with Enterprise manager or Query analyser. You have to
use the command prompt utilizty OSQL to execute all
the TSQL commands. See the details of OSQL utility in books online.
You could also download and use the WEB data ADMIN free tool from microsoft
site.
http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en
Thanks
Hari
SQL Server MVP
"Manish Sawjiani" <ManishSawjiani@.discussions.microsoft.com> wrote in
message news:42FB064A-B6B7-4F20-A3D4-C437096682E1@.microsoft.com...
> Dear Experts,
> I have downloaded MSDE 2000RelA and i installed it. But where is the
> Enterprise Manager and Query Analyzer a-la SQL Server 7.0? Any help would
> be
> greatly appreciated
> Thanks
> Manish
> --
> Three Cheers to Technet for the Help!|||Thanks Hari
--
Three Cheers to Technet for the Help!
"Hari Prasad" wrote:
> Hi,
> MSDE will not come with Enterprise manager or Query analyser. You have to
> use the command prompt utilizty OSQL to execute all
> the TSQL commands. See the details of OSQL utility in books online.
> You could also download and use the WEB data ADMIN free tool from microsoft
> site.
> http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en
> Thanks
> Hari
> SQL Server MVP
>
> "Manish Sawjiani" <ManishSawjiani@.discussions.microsoft.com> wrote in
> message news:42FB064A-B6B7-4F20-A3D4-C437096682E1@.microsoft.com...
> > Dear Experts,
> > I have downloaded MSDE 2000RelA and i installed it. But where is the
> > Enterprise Manager and Query Analyzer a-la SQL Server 7.0? Any help would
> > be
> > greatly appreciated
> >
> > Thanks
> > Manish
> > --
> > Three Cheers to Technet for the Help!
>
>

MSDE 2000 Downloaded and Installed But where is Enterprise Manager

Dear Experts,
I have downloaded MSDE 2000RelA and i installed it. But where is the
Enterprise Manager and Query Analyzer a-la SQL Server 7.0? Any help would be
greatly appreciated
Thanks
Manish
--
Three Cheers to technet for the Help!Hi,
MSDE will not come with Enterprise manager or Query analyser. You have to
use the command prompt utilizty OSQL to execute all
the TSQL commands. See the details of OSQL utility in books online.
You could also download and use the WEB data ADMIN free tool from microsoft
site.
http://www.microsoft.com/downloads/...&displaylang=en
Thanks
Hari
SQL Server MVP
"Manish Sawjiani" <ManishSawjiani@.discussions.microsoft.com> wrote in
message news:42FB064A-B6B7-4F20-A3D4-C437096682E1@.microsoft.com...
> Dear Experts,
> I have downloaded MSDE 2000RelA and i installed it. But where is the
> Enterprise Manager and Query Analyzer a-la SQL Server 7.0? Any help would
> be
> greatly appreciated
> Thanks
> Manish
> --
> Three Cheers to technet for the Help!

MSDE 2000

I downloaded MSDE from microsoft. When I click on Setup.exe I get this message:-

A SA password is required for security reasons. Use SAPWD switch to supply the same.

What does this mean and how can I sort it out?

Many thanks

Jim::I downloaded MSDE from microsoft. When I click on Setup.exe I get this message:-

lets see.

::A SA password is required for security reasons.

You need to provide a password for the user SA in the database. The SA user is the Administrator of the database server.

::Use SAPWD switch to supply the same.

You need to speficy this password using - a command line parameter, called a switch.|||How do I do that?

Cheers

Jim|||Look at the bottom of this page...

http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1|||just run setup.exe SAPWD="passwd" in the cmd line

MSDE 1.0 TO MSDE 2000 Release A

I've used MSDE 1.0 for a number of years.
Today I downloaded Release A with the intention of installing it, but when I
attempt to run Setup I get a dialog saying "The instance name specified is
invalid." What could be causing this?
Also... what impact will an installation of MSDE 2000 have on my existing
MSDE 1.0 databases? Is there a procedure I should be following?
Thanks in advance.
Nancy
hi Nancy,
"Nancy Lorieau" <NancyLorieau@.discussions.microsoft.com> ha scritto nel
messaggio news:81D8BF32-88C8-4F0C-AE24-0C8BCC213BC5@.microsoft.com...
> I've used MSDE 1.0 for a number of years.
> Today I downloaded Release A with the intention of installing it, but when
I
> attempt to run Setup I get a dialog saying "The instance name specified is
> invalid." What could be causing this?
>
personally I never "upgraded" MSDE 1.0 instance to MSDE 2000 ... I always
backedup the users database and restored them on the MSDE2000 new instance
after uninstalling MSDE 1.0.. but I had no reason to maintain the MSDE 1.0
instance at all...
anyway,
http://msdn.microsoft.com/library/de...stsql_84xl.asp
reports you have to add the
UPGRADE=1 UPGRADEUSER=username UPGRADEPWD=userpwd
commandline parameters to your call to the setup.exe bootstrap installer...

> Also... what impact will an installation of MSDE 2000 have on my existing
> MSDE 1.0 databases? Is there a procedure I should be following?
the users databases will be upgraded to MSDE 2000 level... you coul'd be
affected by cross database ownership chaining, which behaviour has been
changed... further info at
http://msdn.microsoft.com/library/de...onfig_8d7m.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.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.0 and SQL Server

Apparently since I downloaded SQL Server SP3 and tried to install it on a computer without SQL Server in the first place, it's a bad thing.

I'm trying to get SQL Server Desktop Engine to install and I do the cmd.exe thing and it works, then 1 second before it finishes it rolls back.

All the files are still there, just missing the ones you need to run the SQL Server.

I used to have it on my 98, before I upgraded. Now I have the ASP.NET WebMatrix on my XP Home.

Is there a way to get SQL to install correctly?

JohnAre you sure you want to install MSDE 1.0?? That is a SQL Server 7-compatible data engine.

There seems to be a good walkthrough on installing MSDE 2000 in the ASP.NET Web Matrix Guided Tour:Install MSDE 2000.

Terri|||I tried that, perfectly and by all the things it said, and it still backed out at the last few seconds.

I have no idea. I've only herd that XP Home dosn't support IIS but this thing had XP (General) as in Home and Pro for the supported OS's. I really don't now whats wrong.

John

MSDE - how do I connect?

Hello -
I downloaded everything and installed MSDE (I'm running Windows 2000
Professional). I can see the instance I installed on my local C drive.
When I click on the icon for Sql Server Service Manager, and click down on
the arrow, there is nothing in there; there also is nothing under Services.
What have I done wrong?
Sandy
hi Sandy,
Sandy wrote:
> Hello -
> I downloaded everything and installed MSDE (I'm running Windows 2000
> Professional). I can see the instance I installed on my local C
> drive.
> When I click on the icon for Sql Server Service Manager, and click
> down on the arrow, there is nothing in there; there also is nothing
> under Services.
> What have I done wrong?
http://support.microsoft.com/default...b;EN-US;814132
you can, if you like and get your sysadmin approval, enable network
protocols as well...
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