MSDE 2000 for Developers Using Visual Studio .NET

[piscis]

I downloaded the

MSDE 2000 for Developers Using Visual Studio .NET

When installing I got this 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.

What is SAPWD and what should I do?

Andy

 

[RiverGuy]

The "sa" account is the administrator password for the MSDE server. If multiple people are going to be accessing data off of your specific server, then you will want to make a password so they can't get into data that's not theirs, etc., etc.

 

[mmatsumura]

581235242,

Glad to have read your question. I am wondering if you've figured it out? If so, PLEASE reply and let me know what was done.

Thanks

 

[FoxyBOA]

Hi 581235242 and mmatsumura !
You could use osql.exe utility to connect to your MSDE database (i.e. osql -S SERVERNAME -Usa)
After that you could use system stored procedure sp_password to change SA's password (i.e. exec sp_password @new ='new_password', @loginame = 'sa'). After you push enter you should type "GO" and also push enter. After that SQL change SA's password from blank to new_password.