Thanks- it wasn't a technical error message- just a box that appeared saying I needed to switch to an sapwd and said the installation program would now close and to read the read me file which didn't say much that made any sense to me- it assumed I already am an expert or something- is it that I need to change my winXP logon password or ? I actually deleted the whole program from my system as it seems such a hassle just to try and install it. I guess I was hoping for something that was easy to use! Maybe it's back to Access with it's built-in GUI.
i'm not familiar with this problem but i have always loaded enterprise edition or the developer edition
if this is a MSDE that might explain it. OR a newer edition post SP3 containing the requirement for the sa account to have a password
it is quite possible that SQL is asking you for an sa password because your version of windows is the home edition and it requires administrative rights to install. and as is usually the case your user account is not admin.
so i would try the following
1 log onto the computer as the administrator account
2 try the install again
3 if it asks you for the sa password again just leave that field blank as initialy the sa account has no password
4 if you can then get into SQL server, open up books online (in the start menu folder) and have it open whenever you use sql server.
Thanks again- as you surmised, it is indeed both "MSDE" and SP3 containing the requirement for the sa account to have a password.
The problem is it's not even letting me install the program at all- it just closes before it even starts after telling me my password isn't up to snuff. I am logged onto XP home as the admin. Is there supposed to be an "sa account" already on my system?
i dont want to sound like a nagging wife BUT when an error message is specific enough to indicate that the answer is in the readme.txt file
you should read it.
it should be in the directory that the setup.exe is located in.
Thanks a bunch- that helps. No worries about nagging- I did read the readme but the references there were cryptic to me- your answer was very succinct and much clearer. I really didn't know what the readme was talking about. Thanks again.
3.4.2 Security Considerations for MSDE 2000 Release A
"By default, Desktop Engine Setup.exe will not install a new instance of MSDE 2000 unless you use the SAPWD parameter to specify a strong sa password. You should always assign a strong password to the sa login unless the application using your instance of MSDE depends in some way on a null sa password. Even if the instance of MSDE 2000 is using Windows Authentication, the sa login becomes immediately active if the instance is ever switched to Mixed Mode. A null, blank, simple, or well-known sa password could be used for unauthorized access"
3.4.3 MSDE 2000 Setup Parameters
This example creates a log file, MSDELog.log, in the root folder of the C: drive:
I don't understand any of that... a guy is building a database for me to use for research and told me to install this program so I can run it. I thought it would be as easy as installing any other program but for whatever reason I need to reprogram all sorts of stuff and it doesn't make sense to me.