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
- :
- Problem of create SQLExpress database on vista
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
‎Jul 13, 2008
09:21 PM
Problem of create SQLExpress database on vista
Now i'm working on a installsheild project.
I wanna run script to create a SQLExpress database during installation. At the point of running script, the debugger stepped in and told me there was an error opening the database connection:
"CREATE DATABASE permission denied in database 'master'................."
And my script like: osql -S localhost\SQLExpress -E -i "C:\a.sql"
How could i give the permission? and how to do it?
thanks for any help
I wanna run script to create a SQLExpress database during installation. At the point of running script, the debugger stepped in and told me there was an error opening the database connection:
"CREATE DATABASE permission denied in database 'master'................."
And my script like: osql -S localhost\SQLExpress -E -i "C:\a.sql"
How could i give the permission? and how to do it?
thanks for any help
(4) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 14, 2008
05:05 AM
why don't you use the InstallShield builtin SQL Scripts support? I never had a problem with it.
It seems that the user running the installer doesn't have permissions over that SQL instance. or there's a problem with your osql syntax; try using "(local)\SQLExpress" instead of "localhost\SQLExpress".
It seems that the user running the installer doesn't have permissions over that SQL instance. or there's a problem with your osql syntax; try using "(local)\SQLExpress" instead of "localhost\SQLExpress".
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 14, 2008
09:04 PM
thanks peter,i use builtin SQL Scripts and it can create database now.
But how can i control the execute sequence? i want to install sqlexpress first and then run script. Now when i run the installer, connect database server dialog come out before the sqlexpress install. i'm working on a installscript project.who knows how to control the run sequence. (i chose script files are belonged to the last application,but the database server dialog still runs first).
thanks for any help or ideas
But how can i control the execute sequence? i want to install sqlexpress first and then run script. Now when i run the installer, connect database server dialog come out before the sqlexpress install. i'm working on a installscript project.who knows how to control the run sequence. (i chose script files are belonged to the last application,but the database server dialog still runs first).
thanks for any help or ideas
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 15, 2008
03:56 AM
I have not used InstallScript projects before. I assume you call the installation of SQLExpress from a function in the InstallScript? Then use an event handler that gets executed at the very beginning of the Installation Sequence. Here is some help: http://helpnet.acresso.com/robo/projects/devstudio9helplangref/LangrefEventHandlers.htm
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 15, 2008
06:02 PM
thank you very much peter,now it works.
![](/skins/images/CC38E504FC9E1309DC48ACFEB4925670/responsive_peak/images/icon_anonymous_message.png)