MSDE 2000a

What is going on with this program?

When I try to install it I get the error message:

"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit."

Runing Win2k server, logged in as Administration.
Readme file says nothing about this
As usual, you can't find anything on M$ KB site.

I also tried the MSDE SP3 version - got the same results.I finally got it to install...had to edit the setup.ini file.

The server is running, the service is running but...

there is no enterprise manager...how are you suppose to manage your databases?|||There are a few things to manage your database. First of all there's the command-line tool called osql.exe that can be used to execute commands on your database. The second option is to use Access projects (supported on Access 2000 and higher if I'm not mistaken). Projects are a way to connect to a SQL Server or MSDE instance from within the Access product (pretty powerful). Last but not least there is the Web Data Administrator that can be downloaded fromhttp://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en.

Hope this can help?|||Hi if anyone is still reading this thread this is very helpfull. I was trying to use MSDE via MATRIX but there seems to be only an option to create tables but not relationships between them so I am wondering how to actually access MSDE directly , which of above 3 ways do you suggest and where do I find more about command line and projects?sql

MSDE 2000 install problem - Setup failed to configure the server

Hi,
I keep getting a "Setup failed to configure the server" message everytime i
try to install MSDE 2000. I have entered a strong pasword, as that was
required, removed any instances of previous msde installations and it makes
no difference.
I have read and followed instructions from various web sites and still no
installation.
Any help/advice appreciated.
Thanks
Jen
P.S. I am running XP SP2
Hello,
When you say that you removed every msde instance, did you remove the
Microsoft SQL Server directory?
My custommers have problems when they uninstall msde and they don't delete
the directory by hand after
Marc Allard
Allcomp
"JenC" <JenC@.discussions.microsoft.com> a crit dans le message de news:
EB81AD99-9F73-4731-B15F-BA1624075E9A@.microsoft.com...
> Hi,
> I keep getting a "Setup failed to configure the server" message everytime
> i
> try to install MSDE 2000. I have entered a strong pasword, as that was
> required, removed any instances of previous msde installations and it
> makes
> no difference.
> I have read and followed instructions from various web sites and still no
> installation.
> Any help/advice appreciated.
> Thanks
> Jen
> P.S. I am running XP SP2
|||If you setup is failing, specify a command line parameter DISABLEROLLBACK =
1, this would stop MSDE Installer from rolling back in case of failure.
Also specify /L*v <log file patch with name>. This would enable setup to
write logs into the specified file. Try to search "return value 3" and
check where did it fail.
Once we know where it is failing we can help better. Also add the logfile
when you reply next.
|||Try changing the parameters you use for setup.exe. For example, I removed the
DISABLENETWORKPROTOCOLS =1 and INSTANCENAME=MSDE2 parameters and it worked
fine after that.
Good luck.
"JenC" wrote:

> Hi,
> I keep getting a "Setup failed to configure the server" message everytime i
> try to install MSDE 2000. I have entered a strong pasword, as that was
> required, removed any instances of previous msde installations and it makes
> no difference.
> I have read and followed instructions from various web sites and still no
> installation.
> Any help/advice appreciated.
> Thanks
> Jen
> P.S. I am running XP SP2
sql

MSDE

Hello,
I'm trying to setup a strong password for my sa account on
a windows 2000 server.
I tried using the instructions from Microsoft Knowledge
base but it keeps giving me a incorrect syntax error
message
Dear Maurice,
I take it that this is the article you are referring to -
322336 HOW TO: Verify and Change the MSDE System Administrator Password
http://support.microsoft.com/?id=322336
Could you please tell us what you executed and what the exact error message
was?
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
|||Dear Maurice,
I take it that this is the article you are referring to -
322336 HOW TO: Verify and Change the MSDE System Administrator Password
http://support.microsoft.com/?id=322336
Could you please tell us what you executed and what the exact error message
was?
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.