This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: Error 27505. Could not open SQL script file
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 13, 2011
11:19 AM
Error 27505. Could not open SQL script file
I keep getting this error when I try to run a script that was created using the Database Import Wizard.
I found references to this error in older forums and posts dating back a few years, and it looks like it was solved with a hotfix.
I have installed HotFix A and have this issue, so I believe I am up-to-date with my 2011 version.
Any ideas?
I found references to this error in older forums and posts dating back a few years, and it looks like it was solved with a hotfix.
I have installed HotFix A and have this issue, so I believe I am up-to-date with my 2011 version.
Any ideas?
(17) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Feb 22, 2011
02:05 PM
I'm seeing this as well in IS 2011. I'm doing an install on a German OS and I'm seeing it. Seems to work on a US install, however.
Still digging into it...
Still digging into it...
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Mar 02, 2011
10:03 AM
I'm encountering the same problem right now. I'm trying to build a basic MSI setup with IS 2011 (with German localization). Doing quite the same with a InstallScript setup it works well.
Currently I'm using a IS 2011 Professional edition in evaluation mode with hotfix Q210896 installed.
Currently I'm using a IS 2011 Professional edition in evaluation mode with hotfix Q210896 installed.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Mar 02, 2011
01:00 PM
I am not able to reproduce the error. Would it be possible for you to post a sample project and SQL script that replicate the behavior so that I can look into the issue?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Mar 03, 2011
12:11 PM
Thank you for the sample project. Unfortunately, it is still not reproducible. I build your setup.ism on an English Windows XP image and run it on a German Windows XP image. The DBVersionSet table was created on the SQLTest database. There are multiple DBSchema.sql files in your zip and I use the one under the SetupSQLTest\SetupSQLTest folder. Is there anything I am missing?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Mar 04, 2011
02:37 AM
Well, I don't know what did the trick but now everything works fine regarding SQL scripts. Even the example I've had uploaded works now - untouched. It definitely didn't work yesterday. Something has changed, I don't know, what...
Anyway, I'm happy so far. Thanks for your support.
Anyway, I'm happy so far. Thanks for your support.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Mar 04, 2011
11:58 AM
Hi,
I just experienced a similar issue, I found it to be due to UAC settings on the target machine. My install was getting change prompts on a Win 7 machine, and generated the same error you were getting when it attempted to access it's first SQL script. I turned off UAC and the issue resolved.
I just experienced a similar issue, I found it to be due to UAC settings on the target machine. My install was getting change prompts on a Win 7 machine, and generated the same error you were getting when it attempted to access it's first SQL script. I turned off UAC and the issue resolved.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Mar 18, 2011
02:40 AM
I can give some updated information about this issue. On my machine the setup runs without any problems. I tried to install it on some different systems with Windows 7 (64bit, German and English). There I got the SQL script file error again.
I tried to install with UAC turned off and it succeeded.
I tried to install the setup in Windows XP compatibility mode and it succeeded.
It looks like a problem with rights. This is strange.
I tried to install with UAC turned off and it succeeded.
I tried to install the setup in Windows XP compatibility mode and it succeeded.
It looks like a problem with rights. This is strange.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎May 24, 2011
08:34 AM
I also get this issue with Installshield 2011, Hotfix A.
Has anyone managed to get this to work with UAC turned on? I do not want to have to tell people to turn UAC off during installation.
Has anyone managed to get this to work with UAC turned on? I do not want to have to tell people to turn UAC off during installation.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎May 24, 2011
07:06 PM
Hi,
I just experienced a similar issue, I found it to be due to UAC settings on the target machine. My install was getting change prompts on a Win 7 machine, and generated the same error you were getting when it attempted to access it's first SQL script. I turned off UAC and the issue resolved.
I just experienced a similar issue, I found it to be due to UAC settings on the target machine. My install was getting change prompts on a Win 7 machine, and generated the same error you were getting when it attempted to access it's first SQL script. I turned off UAC and the issue resolved.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎May 25, 2011
08:13 AM
The problem I have is that the installations often need to be run on servers, and in my experience turning off UAC requires a reboot. As you can expect this would have a big implication. I also want to keep my installation as an MSI file without a setup.exe.
EDIT: also if they decide that they want to remain with UAC on, then they will require a further reboot.
EDIT: also if they decide that they want to remain with UAC on, then they will require a further reboot.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 12, 2011
12:26 PM
We just ran into this issue as well after upgrading to InstallShield 2011. Asking end users to turn off UAC is not a viable option. Are there any other workarounds or changes that can be made. We did not have this issue before upgrading to InstallShield 2011 (we were previously using InstallShield 12).
I didn't see anyone from InstallShield reply to this thread after it was revealed this appears to be an issue related to UAC. I would be nice to get some response from InstallShield on this issue.
Thanks,
Shane
I didn't see anyone from InstallShield reply to this thread after it was revealed this appears to be an issue related to UAC. I would be nice to get some response from InstallShield on this issue.
Thanks,
Shane
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 12, 2011
08:05 PM
Was there a solution to this issue? What is the main cause. I have just created a project which only installs MSSQL Express 2008 R2 and when it tries to deploy the database I get the same error message. I used the Database Import wizard to create the SQL script in the InstallShield project.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 12, 2011
09:20 PM
Ah yes it is related to UAC. I turned it off in a windows 7 virtual machine and viola the databases would deploy on the server.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 13, 2011
01:48 AM
Confirming that Turning on Compatibility mode for the setup with Run this program as Administrator did allow the scripts to work fine. What is the work around because I don't want thousands of calls from clients when it throws up the error message about the scripts not working.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 13, 2011
02:13 AM
It only took all day but I found the solution.
For the Release in the Setup.exe tab I made the "Required Execution level" Highest available instead of Invoker and the script finally worked. Perhaps Admin would work as well. But it working now so i'm keeping it 😃
Hope this helps you all.
For the Release in the Setup.exe tab I made the "Required Execution level" Highest available instead of Invoker and the script finally worked. Perhaps Admin would work as well. But it working now so i'm keeping it 😃
Hope this helps you all.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 28, 2011
03:20 PM
Below is the Installshield Hotfix for the issue related to the issue. After building the msi using Installshield 2011 using the fix, you will be able to run the msi on Windows 7 or Vista with UAC enabled without issue.
The hot fix for the SQL problem is documented in Knowledge Base article, Q211641, and can be found at: http://support.installshield.com/kb/view.asp?articleid=Q211641
The hot fix for the SQL problem is documented in Knowledge Base article, Q211641, and can be found at: http://support.installshield.com/kb/view.asp?articleid=Q211641
![](/skins/images/8CE4FAD0DE6F3A6F9D0567434D2D2DAE/responsive_peak/images/icon_anonymous_message.png)