I wrote an application that downloads SQL Express 2008 with the Wix 3.5 installer, and then tries to CREATE a DATABASE when I first run the application. Thus, the installation of SQL Express is fully automated. All this works great when the account installing the application is the administrator on the computer.
However, somewhat unsurprisingly, problems arise when installing as non-admin. When we try to run CREATE DATABASE sql it squarks -
sql express 2008 create database permission in database "master"
Obviously, a standard user account does not have the correct privilege. Therefore, we need to give standard users the right privileges. I was thinking of combining a separate executable file, which should run as Admin (via UAC), which would create a database and assign privileges in the new database for the user account - not a very elegant solution.
This seems like the obvious thing you want to do when deploying the application, but there seems to be a lack of information on this. Look for suggestions - thanks.
source
share