Install

I just installed sql server 2005 express and everything seemed to go well. However I only see the configuration tools under program files in the start menu.

Any suggestions would be appreciated.

Thanks!

I'd suggest that you start using SQL Express! (Sorry, had to do it.)

SQL Express only includes the database engine and the configuration tools, so you're seeing exactly what you should. You can work with the engine using a number of different tools, here are a few:

SQLCmd - Command line tool included with SQL Express to run T-SQL Commands.|||

Thanks, this helps.

I actually wanted to initially load the free msde but got an error that said:

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

I downloaded msde 2000 release A. Is that the correct version for the old msde?

Can you give me any advice on this. Thanks!

David

|||

Hi David,

SQL Express is newer than MSDE 2000 and offers some improved functionality, but if you want to use the older version...

I would go for MSDE 2000 SP4 since that is newer than Release A. The behavior you describe is by design since you must supply a strong password for the SA account when installing MSDE. The readme file that is available on the download page for MSDE explains how to install it and the correct usage of the SAPWD switch.

Mike