Wednesday, March 28, 2012

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

No comments:

Post a Comment