Strong SA password

On running the setup file, I got this message when trying to run msde:

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

Advice on this issue would be appreciated.

Thanks.



Answer this question

Strong SA password

  • Mark Storen

    It actually came up with this message as I ran the installer. I did not even get a chance to get to the password setup screen.

    Thanks.


  • Jerrie Pelser

    Please provide us with the appropiate parts of the setup logfile.

    Jens K. Suessmeyer

    ---
    http://www.sqlserver2005.de
    ---


  • ie1jch

    Hi,

    I think you forgot to pass the SAPQD switch which passes the sa password to the installer. You have to provide a sa apssword to install the MSDE.

    http://support.microsoft.com/default.aspx/kb/810826

    HTH; Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---


  • LTR

    Here is an example of the command using the password install:

    C:\MSDERelA\setup.exe SAPWD="install"

    this is assuming the setup file is in the default directory MSDERel

    Good luck,

    Gerry Loranger



  • Todd Segal

    YOu have to provide it as a switch on the commandline, see the link above that I posted for syntax of the commandline.

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • Gary_MN

    I ended up just adding the following lines to the setup.ini file

    [Options]
    UID="Password"
    SAPWD="Password"

    But now I am having an issue... it starts to install the software but with 3 seconds left on the time... the progress bar goes backwards like its uninstalling everything that it had done. Could somebody help me with this

    Thanks


  • Laurence Starks MSFT

    Thanks, I also had a similar problem to this. I think it's just that the solution wasn't that evident in the support article previously mentioned.

    It could have saved a lot of time by stating "Run the setup from the command line as follows: C:\MSDERelA\setup.exe SAPWD="password""
    Then explain the importance of the password.

    Thanks

  • Strong SA password