PDA

View Full Version : Generic SQL execution error



AJFabre
07-23-2014, 10:59 AM
We have an InstallShield 2014 Professional InstallScript project which runs many scripts against SQL Server 2008 R2 or 2012. During QA testing, SQL execution failed with the following generic message: "There was an unexpected error running SQL scripts. Setup will now terminate." We have been unable to replicate this error at will and have not been fortunate enough to experience this issue while a SQL profiler is running.

Would it be possible for someone to list some of the possible causes for this generic error? We are able to obtain detailed error messages when SQL scripts fail and are exploring the possibility of adding code to detect the specific causes for these unknown errors. Any insight would be greatly appreciated.