Microsoft SQL Server Desktop Engine

Author

Strong SA Password

Frank

2005-06-17, 9:23 am

After running the command suggested in a previous post, (and it looked like
it worked except for the backward progression of the status bar at the end) I
am still
getting the same error:

> A strong SA password is required for security reasons Please use SAPWD
> switch to supply the same.

Any idea why I would get this error upon double-clicking setup.exe after
setting up secure password? I restarted.

Thanks in advance for your help.

Andrea Montanari

2005-06-17, 11:24 am

hi Frank,
Frank wrote:
> After running the command suggested in a previous post, (and it
> looked like it worked except for the backward progression of the
> status bar at the end) I am still
> getting the same error:
>
>
> Any idea why I would get this error upon double-clicking setup.exe
> after setting up secure password? I restarted.
>
> Thanks in advance for your help.

instead of clicking on the setup.exe, please provide all required
parameters..
SAPWD=some_password
is one of the, actually the only mandatory one..
please have a look at
http://msdn.microsoft.com/library/d...istsql_84xl.asp
for the list of all supported parameters...

please add the
/L*v "c:\MsdeLog.txt"
parameter to you setup.exe call in order to enable verbose logging of the
installation process... this will result in an about 2mb text file (for a
completed installation) you can inspect for
RETURN VALUE 3
entries... each entry will indicate a problem.... about 10/15 lines before
each entry some (sometimes cryptic) description of the problem found will be
reported...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Frank

2005-06-20, 7:23 am

Andrea,
Thanks for responding, but I'm still in need of further information. My
responses are below.

"Andrea Montanari" wrote:

> hi Frank,
> Frank wrote:
>
> instead of clicking on the setup.exe, please provide all required
> parameters..
-I don't require any parameters, I just want the default database to insall.
> SAPWD=some_password[
/color]
-As far as I know, I did this already. I have seen it done two ways and
have tried both with no success:
C:\MSDERela\setup sapwd="password"
C:\MSDERela\setup.exe sapwd="password"
-Does it make a difference which one of these that I run?[color=darkred]
> is one of the, actually the only mandatory one..

> please have a look at
> http://msdn.microsoft.com/library/d...istsql_84xl.asp
> for the list of all supported parameters...
-I don't need anything additional, I really don't even want to set up the
password, but realize it is required.
>
> please add the
> /L*v "c:\MsdeLog.txt"
-How do I add a .txt file to a .exe? And where would expect to see this 2mb
text file?
> parameter to you setup.exe call in order to enable verbose logging of the
> installation process... this will result in an about 2mb text file (for a
> completed installation) you can inspect for
> RETURN VALUE 3
> entries... each entry will indicate a problem.... about 10/15 lines before
> each entry some (sometimes cryptic) description of the problem found will be
> reported...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>
-Thanks again for your help
>

Andrea Montanari

2005-06-20, 7:23 am

hi Frank,
Frank wrote:

> -I don't require any parameters, I just want the default database to
> insall.

actually you need them, as longa s you have to provide 1 of them at least...

> -As far as I know, I did this already. I have seen it done two ways
> and have tried both with no success:
> C:\MSDERela\setup sapwd="password"
> C:\MSDERela\setup.exe sapwd="password"
> -Does it make a difference which one of these that I run?

try
C:\MSDERela\setup.exe SAPWD="password"
do not think it's case sensitive, but never tryed...
[color=darkred]
> -How do I add a .txt file to a .exe? And where would expect to see
> this 2mb text file?

C:\MSDERela\setup.exe SAPWD="password" /L*v "c:\MsdeLog.txt"

--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Frank

2005-06-20, 9:23 am

Thanks again for responding.
OK, ran the SApwd parameter again. Afterwards tried double-clicking
setup.exe and got same error message. Added log as suggested and ran again
to populate log. I don't see the log text file anywhere to share that with
you.
Some troubleshooting ideas/questions
1. Does the strong SAPWD actually have to be strong? I.E. am I being
rejected because I am not making passwords up to snuff?
2. I have run setup.exe sapwd:"differentpasswords" many times, am I
resetting each time I run this parameter or am I corrupting the file by
running so many times?
3. When running the sapwd parameter, is it normal for the progress bar to
go backwards (disappearing right to left) when the parameter execution comes
to an end?

What is this?

>
> actually you need them, as longa s you have to provide 1 of them at least...
>

"Andrea Montanari" wrote:

> hi Frank,
> Frank wrote:
>
>
> actually you need them, as longa s you have to provide 1 of them at least...
>
>
> try
> C:\MSDERela\setup.exe SAPWD="password"
> do not think it's case sensitive, but never tryed...
>
>
> C:\MSDERela\setup.exe SAPWD="password" /L*v "c:\MsdeLog.txt"
>
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>
>
>

Andrea Montanari

2005-06-20, 11:23 am

hi Frank,
Frank wrote:
> Thanks again for responding.
> OK, ran the SApwd parameter again. Afterwards tried double-clicking
> setup.exe and got same error message. Added log as suggested and ran
> again to populate log. I don't see the log text file anywhere to
> share that with you.

wait a moment... you have to run that command from a command prompt
window...
c:\...>setup.exe SAPWD="xxxx" /L*v "C:\MsdeLog.txt"
that's all
do not double click on it, or provide a setup.ini file with the required
parameters... and a SAPWD is not a parameter I'd save in an INI file

http://msdn.microsoft.com/library/d...istsql_84xl.asp
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

jrbtech@gmail.com

2005-07-11, 3:23 am

the answer is here:
http://www.jrbtech.com/index.php/te...Return_value_3/

Sponsored Links