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