Installing MSDE

After a number of tries I have not been able to successfully install the MSDE 2000 Desktop engine.. I downloaded the file, followed all instructions in the ReadMe and now have a folder "Microsoft SQLServer" in the Program Files. This folder contains 2 s
ub folders "80" and "MSSQL$VSdotNet". These have sub folders which I have serched but cannort locate an executable file that gives me any kind of interface to design or use a database.
In the past, all my database have been in MS Access2000. Am I expecting too much of san Access type of look?
I am at a complete loss as to where to go from here in using the MSDE and getting the sample databases to load. If anyone can point me to a place to look fo a tutorial or simple set of instructions, I would appreciate it, much.
I am using Windows XP Pro.
Milt
hi Milt,
"sirmilt" <sirmilt@.discussions.microsoft.com> ha scritto nel messaggio
news:534F95C8-7C68-45F3-A2CE-6C4995F2B57D@.microsoft.com...
>....
please post your command line...
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
|||Hello sirmlt,
welcome to the MSDE group. MSDE does not come with a graphical UI tool. To administer it you can download the free tools online for e.g. MSDEManager or dbamanager by Andrea from http://www.asql.biz/DbaMgr.shtm.
This will give you a tool to administer the sql server, for e.g. to create logins, users etc. Then to create your database you can use t-sql statements in .net to create the db dynamically but if you want to create it using UI then the server explorer in
vs.net will let you connect to the server (which will be your machine if you install MSDE there) nad create database. Or you can install SQL Server developer edition (cheaper cost wise and for development purposes). This will provide you with both the
tool to administer the databases (It is called Enterprise Manager) and you can create/modify the db there itself.
Let us know if you have any more questions.
goodluck
dev
"sirmilt" wrote:

> After a number of tries I have not been able to successfully install the MSDE 2000 Desktop engine.. I downloaded the file, followed all instructions in the ReadMe and now have a folder "Microsoft SQLServer" in the Program Files. This folder contains 2
sub folders "80" and "MSSQL$VSdotNet". These have sub folders which I have serched but cannort locate an executable file that gives me any kind of interface to design or use a database.
> In the past, all my database have been in MS Access2000. Am I expecting too much of san Access type of look?
> I am at a complete loss as to where to go from here in using the MSDE and getting the sample databases to load. If anyone can point me to a place to look fo a tutorial or simple set of instructions, I would appreciate it, much.
> I am using Windows XP Pro.
> --
> Milt
|||Thank you for the response. Your answer clears up my misunderstanding of the interface with the MSDE. I looked at the web site you suggested and it is all in Italian, I hope there is an english version, I will be trying it out over the next couple of day
s.
Milt
"dev_kh" wrote:

> Hello sirmlt,
> welcome to the MSDE group. MSDE does not come with a graphical UI tool. To administer it you can download the free tools online for e.g. MSDEManager or dbamanager by Andrea from http://www.asql.biz/DbaMgr.shtm.
> This will give you a tool to administer the sql server, for e.g. to create logins, users etc. Then to create your database you can use t-sql statements in .net to create the db dynamically but if you want to create it using UI then the server explorer
in vs.net will let you connect to the server (which will be your machine if you install MSDE there) nad create database. Or you can install SQL Server developer edition (cheaper cost wise and for development purposes). This will provide you with both th
e tool to administer the databases (It is called Enterprise Manager) and you can create/modify the db there itself.[vbcol=seagreen]
> Let us know if you have any more questions.
> goodluck
> dev
> "sirmilt" wrote:
2 sub folders "80" and "MSSQL$VSdotNet". These have sub folders which I have serched but cannort locate an executable file that gives me any kind of interface to design or use a database.[vbcol=seagreen]
|||dev_kh
Thank you for replying. I took a brief look at the site you suggested and it's in Italian. I will download and hope for an english version.
Thanks Again
Milt
"dev_kh" wrote:

> Hello sirmlt,
> welcome to the MSDE group. MSDE does not come with a graphical UI tool. To administer it you can download the free tools online for e.g. MSDEManager or dbamanager by Andrea from http://www.asql.biz/DbaMgr.shtm.
> This will give you a tool to administer the sql server, for e.g. to create logins, users etc. Then to create your database you can use t-sql statements in .net to create the db dynamically but if you want to create it using UI then the server explorer
in vs.net will let you connect to the server (which will be your machine if you install MSDE there) nad create database. Or you can install SQL Server developer edition (cheaper cost wise and for development purposes). This will provide you with both th
e tool to administer the databases (It is called Enterprise Manager) and you can create/modify the db there itself.[vbcol=seagreen]
> Let us know if you have any more questions.
> goodluck
> dev
> "sirmilt" wrote:
2 sub folders "80" and "MSSQL$VSdotNet". These have sub folders which I have serched but cannort locate an executable file that gives me any kind of interface to design or use a database.[vbcol=seagreen]
|||> Thank you for replying. I took a brief look at the site you suggested and
it's in Italian.
>I will download and hope for an english version.
hey... I'm italian, thought =;-D
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
|||dev_kh
Thanks for the response. I download what appears to be the right file and will try it out, I appreciate your trying to help out this novice.
Milt
"dev_kh" wrote:

> Hello sirmlt,
> welcome to the MSDE group. MSDE does not come with a graphical UI tool. To administer it you can download the free tools online for e.g. MSDEManager or dbamanager by Andrea from http://www.asql.biz/DbaMgr.shtm.
> This will give you a tool to administer the sql server, for e.g. to create logins, users etc. Then to create your database you can use t-sql statements in .net to create the db dynamically but if you want to create it using UI then the server explorer
in vs.net will let you connect to the server (which will be your machine if you install MSDE there) nad create database. Or you can install SQL Server developer edition (cheaper cost wise and for development purposes). This will provide you with both th
e tool to administer the databases (It is called Enterprise Manager) and you can create/modify the db there itself.[vbcol=seagreen]
> Let us know if you have any more questions.
> goodluck
> dev
> "sirmilt" wrote:
2 sub folders "80" and "MSSQL$VSdotNet". These have sub folders which I have serched but cannort locate an executable file that gives me any kind of interface to design or use a database.[vbcol=seagreen]
|||Andrea
I did download and install the program suceessfully. I'm a comparative novice at programming, however, and have to struggle with some of the settings as I'm not sure exactly what is needed.
I do appreciate your taking the time to try and help me.
Milt
"Andrea Montanari" wrote:

> it's in Italian.
> hey... I'm italian, thought =;-D
> --
> 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
>
|||Andrea
I did download and install the program suceessfully. I'm a comparative novice at programming, however, and have to struggle with some of the settings as I'm not sure exactly what is needed.
I do appreciate your taking the time to try and help me.
Milt
"Andrea Montanari" wrote:

> it's in Italian.
> hey... I'm italian, thought =;-D
> --
> 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
>
|||Mime-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Trace: news.uni-berlin.de WRwDGb8hXM5vooZ9AkxMRAxL6OyRmZqCnfNc+olhAQgA9jRmO8
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Path: TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!fu-berlin.de!uni-berlin.de!not-for-mail
Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.msde:16464
hi Milt,
"sirmilt" <sirmilt@.discussions.microsoft.com> ha scritto nel messaggio
news:37427C61-4E89-4529-8969-DA73200715C7@.microsoft.com...
> Andrea
> I did download and install the program suceessfully. I'm a comparative
novice at programming, however, and have to struggle with some of the
settings as I'm not sure exactly what is needed.
> I do appreciate your taking the time to try and help me.
thank you for your interest in this prj of mine... for DbaMgr related
questions, please write me privately about it, in order not to go OT on
microsoft public NG
thank you
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