Hi,
I'v tried to install MSDE 2000 and at the begining it requires a
strong SA password.
I don't know what it is or how to install/configure it so i can't
install the MSDE 2000.
If anyone knows how to dill with it please specify the steps required
for using the sapwd and installing the MSDE 2000.
Thanks.
----------------------------------------------------------
----------------------------------------------------------
color]
When you installed your OS, you were asked to supply a password for the
default administrator account. If you did not supply a password, or have
forgotten it, you can (if you are running with administrative privileges)
create a new administrator account, give it a password, then use that
password when installing MSDE.
Here is a quote from instructions I give students that may be helpful:
<quote>
1. Before you begin, check the PC to ensure there are no remnants of prior
MSDE installation attempts hanging around. The place to check is: C:\Program
Files\Microsoft SQL Server. If you locate a folder named Microsoft SQL
Server, delete it and its contents!
2. Execute the file: SQL2KDeskSP3.exe. This step will extract the contents
of the file to a designated folder. Make a note of the destination folder.
You'll need it later. This step does not install MSDE (although the dialogs
seem to hint that it does)!
3. Navigate to the folder you created in Step 2. In that folder, you will
find a subfolder named MSDE. In MSDE, you will find SETUP.EXE. Executing
SETUP.EXE will install MSDE.
4. To execute SETUP.EXE correctly, you must supply an instance name and a
system administrator password as part of the command: i.e. the command must
be:
SETUP.EXE INSTANCENAME="NetSDK" SAPWD="yourSAPassword"
where yourSAPassword is your actual system administrator password. This
password is needed only to install MDSE, not to use it. Access to MSDE is
controlled by normal "NT Security" which should allow users access based on
network logon and password. It is very important the the INSTANCENAME
parameter be NetSDK, as this name will enable you to generate the sample
databases automatically instead of having to run SQL scripts from the
command line.
5. Once installation is complete, you must reboot the PC before you will see
MSDE. After the reboot, you should see the MSDE icon in SysTray.
</quote>
Note that the reference to the instance name as NetSDK applies only if you
are installing MSDE for use with Visual Studio .NET and you will want to run
the scripts supplied to install the sample databases in your MSDE instance.
