BlankSAPWD

[ciptojohn]

Hi,
we have this issue of blank sa login password.
we have tried lots of thing but not working.
anyone knows how to workaround this?


Hi,

I'm a colleague of the threadstarter - ciptojohn.

It seems that a reply needs to be approved by administrator, so I asked ciptojohn to include my reply below. Thanks.

Just wanted to add more details, at first we have the LoadSQLLibrary error - thread: https://community.flexerasoftware.com/showthread.php?219924-LoadSQLLIbrary-error

We then try to create the InstallShield .ism from scratch but haven't been successful so far.

The dialogs, UI, Executions are run / displayed successfully during installation, but up to the last step where we click on the Install button, it gives the SetupError dialog box, saying error 2869.

The following is the log:

MSI (s) (4C:BC) [16:16:51:975]: Doing action: DetectBlankSaLogin.2D02443E_7002_4C0B_ABC9_EAB2C064397B
Action 16:16:51: DetectBlankSaLogin.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
Action start 16:16:51: DetectBlankSaLogin.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
MSI (c) (20:5C) [16:16:51:976]: Font created. Charset: Req=0, Ret=0, Font: Req=MS Shell Dlg, Ret=MS Shell Dlg

Error 2869. The dialog SetupError has the error style bit set, but is not an error dialog.
MSI (c) (20:5C) [16:16:53:857]: Product: Forecaster -- Error 2869. The dialog SetupError has the error style bit set, but is not an error dialog.

MSI (s) (4C:BC) [16:16:53:858]: Product: Forecaster --

Action ended 16:16:53: DetectBlankSaLogin.2D02443E_7002_4C0B_ABC9_EAB2C064397B. Return value 3.
Action ended 16:16:53: INSTALL. Return value 3.

I have tried the following suggestions to no avail:
- pass param BLANKSAPWD=1 - http://dbaspot.com/sqlserver-tools/225378-sp4-installation-print.html
- re-arrange action steps in tables - http://forum.installsite.net/index.php?showtopic=7345
- include SQLrelated merger module in Redistributables, including InstallShield MSDE 2000 object for NT platforms

If you have any suggestions, comments it'd be very much appreciated.

Thanks,
mentospure

[mentospure]

Hi,

I'm a colleague of ciptojohn the thread starter.

Just wanted to add more details, we have existing InstallShield config file (.ism) which can generate the .msi file successfully but it has some errors during build, the InstallShield says something about it cannot find merge modules SQLSERV, SQLAGENT.
So I download the .msm via Redistributables.
The errors are all gone.

The problem is, everytime we try to install the .msi it always fails, from the log it says the following:

Action start 18:02:42: GetSqlStates.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{4E3FF4EB-FF93-47A7-AB70-9E02CD298407}
Failed to determine supports files directory in LoadSqlLibrary
CustomAction GetSqlStates.2D02443E_7002_4C0B_ABC9_EAB2C064397B returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
Action ended 18:02:42: GetSqlStates.2D02443E_7002_4C0B_ABC9_EAB2C064397B. Return value 3.
Action 18:02:42: SetupCompleteError.
Action start 18:02:42: SetupCompleteError.
Info 2898. For Tahoma8 textstyle, the system created a 'Tahoma' font, in 0 character set.
Info 2898. For TahomaBold10 textstyle, the system created a 'Tahoma' font, in 0 character set.
Action 18:02:42: SetupCompleteError. Dialog created
Action ended 18:02:44: SetupCompleteError. Return value 2.
Action ended 18:02:44: INSTALL. Return value 3.

From the Interweb, we have tried the following:
- swap the order of AppSearch after LaunchConditions - https://groups.google.com/forum/#!topic/microsoft.public.win2000.msi/WEGxHiv0v2o
- run the msi via command prompt As Admin

If you have any suggestions it'd be very much appreciated.

Thanks,
mentospure