Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MS SQL 2000 Desktop Engine

    Hi all,

    I am trying to install MS SQL 2000 Desktop Engine, when i run the setup.exe file the following error message appears.
    " A strong password is required for security reasons. Please use SAPWD to supply the same. Refer to read me for more details. Setup will now exit."

    Any help I would really appreciated.

  2. #2
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MS SQL 2000 Desktop Engine

    Did you read the read me file?

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: MS SQL 2000 Desktop Engine

    It is due to the fact you are using a simple word as a password such as noun or common name or word which word generators can easily hack. Try adding a numeral into the password.

    I see people use a number instead of a letter in this fashion

    W00dy
    L0unge
    Rud1

    That will work
    Jerry

  4. #4
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MS SQL 2000 Desktop Engine

    Hi again,

    How do I change the password?

    Thanks,

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: MS SQL 2000 Desktop Engine

    Sorry for the delay in getting back, another 14 hour day <img src=/S/nuts.gif border=0 alt=nuts width=15 height=15>

    Open up the setup.ini file and look for

    setup SAPWD="MyStr0ngPW"


    I added MyStr0ngPW to show you the example. Of course you won't be able to adjust the CD ROM so copy the installation files temporarily to your C: drive.
    Jerry

  6. #6
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MS SQL 2000 Desktop Engine

    Hi Jezza thanks for replying. I have downloaded the files into C: drive.I have also opened setup.ini file but it only contains the following text. [Options]

    Thanks

  7. #7
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: MS SQL 2000 Desktop Engine

    OK let's start right from the beginning.

    Download the MSDE from:
    http://www.microsoft.com/sql/downloads/2000/sp3.asp

    Select 'SQL2kdesksp3.exe' and save it to your computer.

    Double-click on the SQL2kdesksp3.exe you downloaded.

    Once you have run the self extracting exe (SQL2kdesksp3.exe), go to a command prompt.

    Start > Run > cmd

    Navigate to the directory you expanded the self extracting exe to and change to the MSDE subdirectory.

    The default is C:sql2ksp3

    Type Setup SAPWD=(Some password) SecurityMode=SQL

    After that gets done running, MSDE is installed.

    Start services

    To get the SQL Server running and the SQL Agent we need start the services.

    right click My Computer > manage > services

    Double click the following and set to Automatic.

    MSSQLSERVER
    SQLSERVERAGENT

    Make sure both are on automatic.


    Make the folder:
    C:Program FilesMSDE Manager

    Extract files to that folder.
    Open the folder and Oppsite click the mouse and drag to the desktop and select create shortcut here.

    Restart your computer.

    You should now have MSDE running and ready to go to start using. Use the MSDE Manager to do your basic SQL Server things.
    Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •