Error 27502 only when "Allow installation to SQL Server Express" is selected
We are using InstallShield 2009 Professional Edition. It is an InstallScript MSI project. Under SQL Scripts | New SQL Connection1 | Requirements tab, so long as I don't select "Allow installation to Microsoft SQL Server Desktop Engine / SQL Server Express" checkbox, everything works well. i.e. we can select a remote SQL Server during installation and the database and tables are successfully created.
If on the other hand, we select this checkbox, then the built SETUP returns error 27502 when we select a remote SQL Server. It works fine if we select the local SQL Express however. The same SETUP works fine if installed on the SQL Server box. The error line shows the local machine name and a dollar sign everytime: "Could not connect to Microsoft SQL Server: "EDS-PPROVISIONI". Login failed for user nae\rrxp01$. (18456).
When SQL Server Express checkbox is turned on, why does the SETUP always use the machine$ account? The General tab is set to use Windows authentication.
Please ignore this post as the problem is now resolved by changing the ISSqlServerInstall action to deferred execution from deferred execution in system context. Thanks.
