Installing MSDE2000

Hi,
I've been trying to follow Microsoft's instructions on installing MSDE2000 for Visual Studio. I do instancename=VSDOTNET SECURITY=SQL SAPWD=XXXX and all that. When I reboot, I notice that I have no services in the SQL Service Manager, nor can it find my computername.

Anybody know why this is?This is on Windows XP professional SP1.

INSTALLING MSDE

I followed all instructions, then I got an example from microsoft on creating a database, it isjust a visual basic example, it has a button create database and it says sql server not found but i can see it on the tray that it is running and using the web interface i can see the databases so i dont know why doesnt the microsoft created example doesnt work.
Thank youShell out to a DOS prompt and type in

osql -L

This will provide you a list of the SQL servers you have access to.

Now, compare this server name to the name of the server in the connection string you are using.

Do they match?

If they match, please provide the connection string you are using and the exact error message you are getting.

Terri

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

Installation/Connection problems with MS Desktop Engine

Actually, it appears to install fine. I used the command line parameters
setup SAPWD="strongpassword" SECURITYMODE=SQL as the instructions described.
I've tried with the double quotes and without. I've tried on a machine
running Windows 2000 and XP (home addition). I tried updating the XP
machine with XP service pack.
No matter what I try, it apperas to install fine. When I attenpt to connect
to the engine (through the ASP.Net Web Matrix), I select SQL Server
Authentication. I then enter "SA" (No quotes, I've tried both upper and
lower case) as the user and the strongpassword that I used as the parameter
when installing. Everytime I get the same message.
Unable to connect to the database server. SQL Server does not exist or
access denied. ConnectionOpen (Connect()).
I can tell the engine is running because its icon in the tray is running.
What am I missing?
Steve,
You may have installed with SA and strong password (Sql authentication) but I believe the install defaults to Windows authentication.
Follow the below to make sure ... (excerpt from KB-322336)
******
If you are not sure how to verify the authentication mode of your MSDE installation, you can check the corresponding registry entry. By default, the value of the Windows LoginMode registry subkey is set to 1 for Windows Authentication. When Mixed Mode authentication is enabled, this value is a 2.
a.. The location of the LoginMode subkey depends on whether you installed MSDE as the default MSDE instance or as a named instance. If you installed MSDE as the default instance, the LoginMode subkey is located in the following registry subkey:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
b.. If you installed MSDE as a named instance, the LoginMode subkey is located in the following registry subkey:
HKLM\Software\Microsoft\Microsoft SQL Server\%InstanceName%\MSSQLServer\LoginMode
NOTE: Before you switch authentication modes, you must set a sa password to avoid exposing a potential security hole
******
Hope this helps,
Tunji
"Steve Wash" <swash1@.home.com> wrote in message news:79GdnaCfS4T2AtbcRVn-tQ@.comcast.com...
Actually, it appears to install fine. I used the command line parameters
setup SAPWD="strongpassword" SECURITYMODE=SQL as the instructions described.
I've tried with the double quotes and without. I've tried on a machine
running Windows 2000 and XP (home addition). I tried updating the XP
machine with XP service pack.
No matter what I try, it apperas to install fine. When I attenpt to connect
to the engine (through the ASP.Net Web Matrix), I select SQL Server
Authentication. I then enter "SA" (No quotes, I've tried both upper and
lower case) as the user and the strongpassword that I used as the parameter
when installing. Everytime I get the same message.
Unable to connect to the database server. SQL Server does not exist or
access denied. ConnectionOpen (Connect()).
I can tell the engine is running because its icon in the tray is running.
What am I missing?