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
- :
- Error 27506 error executing sql script
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
‎Oct 19, 2007
08:31 AM
Error 27506 error executing sql script
I have a script that returns Error 27506. Error executing SQL script (SCRIPT) Line 11. Cannot find the object dbo.GroupServices because it does not exist or you do not have permissions. (1088).
I run the script in the Query Analyzer and the script runs fine, when I run the installshield installer with the same script in it using windows authentication to connect to the sql server and database It gives me this error everytime.
I run the script in the Query Analyzer and the script runs fine, when I run the installshield installer with the same script in it using windows authentication to connect to the sql server and database It gives me this error everytime.
(3) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 19, 2007
10:32 AM
ran sql trace, found out the installer uses user permisions to connect and select the database and server but it is using the system to actually install the script causing the error.
I have not created any custom actions to run the scripts, i just used the normal stuff to add the script and run it. So how do I change the settings so it will run the script as the user instead of the system, I know it is something about it being defered in system context.
I have not created any custom actions to run the scripts, i just used the normal stuff to add the script and run it. So how do I change the settings so it will run the script as the user instead of the system, I know it is something about it being defered in system context.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 19, 2007
11:50 AM
Ok, suuport said
GO to custom actions and right click on it to show all items. Then change ISSQLServerInstall and ISSQLServerUninstall from derfered execution in system context to just defered execution.
This fixed the user specification so it now installs as the user but did not fix the error.
GO to custom actions and right click on it to show all items. Then change ISSQLServerInstall and ISSQLServerUninstall from derfered execution in system context to just defered execution.
This fixed the user specification so it now installs as the user but did not fix the error.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 22, 2007
10:59 AM
Fixed problem, It seems that when I was installing 3 scripts and making the user choose a server and database for each script since they go to differant databases, I had cloned the browser dialog and got one property named wrong so when it would fire off the script the server property was over written and left blank.
All fixed.
All fixed.