Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Question

SQL 2000 Installation

Jul 29, 2012 12:12AM PDT

I am attempting to install MSDE SQL 2000A on my Dell 4700 computer running the XP operating system. I can't get past the password screen where it says that I need to have a strong SA password. Reviewing the base knowledge 322336 it says to type "osql -U sa" at the command prompt. Windows can't find "osql"

So how do I obtain a strong SA password?

Discussion is locked

- Collapse -
Answer
Just sharing.
Jul 29, 2012 3:19AM PDT

When I wanted to develop for SQL I went with MySQL instead. Sorry but if the osql file/command is not in the path or you are not in that folder, it does fail.
Bob

- Collapse -
SQL 2000 Installation
Jul 29, 2012 8:44AM PDT

Thanks. I did download MySQL but the program I'm attempting to download does not recognize that server.
Harvey

- Collapse -
This is starting to sound
Jul 29, 2012 8:49AM PDT

Like it's your first SQL adventure. Microsoft's old 2000 version is challenging enough but I'm left to guess what apps you are writing or using. Sorry but if I have to guess, I will probably guess badly.

Me? Just someone that writes a few frontends for MySQL apps. I can't guess where you are in your journey.
Bob

- Collapse -
Re: MySQL
Jul 29, 2012 5:15PM PDT

You say you downloaded MySQL. That's nice.

But did you actually install it? Do the services run? Can you make your own database either from the command line processor or from the GUI (Query browser)? As long as that doesn't work, any program wanting to create a database surely will fail.

Kees

- Collapse -
My SQL
Jul 30, 2012 6:48AM PDT

Yep it's installed, all 173 MB. Unfortunately I only have one program that requires the SQL server so I don't know how to check it to see if it runs. When I go to programs and click on mysql it take me to something called the Command Line Client. Clicking on that and I get a screen saying to enter a password. I don't have a password. Could that be why I can't run the mysql?

- Collapse -
Re: MySQL
Jul 30, 2012 7:11AM PDT
- Collapse -
MySQL
Jul 30, 2012 10:37AM PDT

Thanks, I'll look it up.
Harv