This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JamesHurst
Level 2
‎Aug 12, 2013 04:57 PM

SQL Scripts not running - why?

Hello, I created an InstallScript installer project, and amongst it's other features/components, it has two SQL Server scripts to run. I added these under "Server Configuration/SQL Scripts", by creating an SQLConnection and then on that connection selecting "Insert Script Files...".

But the SQL scripts are not being executed!

I tried creating just a simplistic installer, with a simple SQL script added in the same manner, with the same parameters for the SQLConnection. That one does execute - I can see the results of what it does within SQL Server. But in my actual installer project, the scripts don't run. And nothing in the log file indicates why.
When should the scripts run, before or after the files are copied over? What would prevent them from executing?

I'm trying to use InstallShield Premier 2012 Spring, on Windows Server 2008. The SQL is going against SQL Server 2008.

Thank you for any help or hints,

James
Labels (1)
Labels
0 Kudos
(1) Reply
hidenori
Level 17
‎Aug 14, 2013 04:46 PM

I would suggest that you debug your InstallScript code and make sure that the OnSQLServerInitialize() and OnSQLComponentInstalled() functions are executed.
0 Kudos