I need to install a SQL Server Express instance (as an admin) which can be later on read and modified by regular users.
I run into http://msdn.microsoft.com/en-us/library/ms254504.aspx, and I'm trying to make it work like it says there, with this connection string:
Provider=sqloledb;Data Source=.\\DUBOCALC;Integrated Security=true;User Instance=true;AttachDBFilename=|DataDirectory|\\" + HelperClasses.DuboCalcSettings.dbname + ".mdf;Initial Catalog=DUBOCALC;Trusted_Connection=yes;
The problem I have is that the instance is created under
C:\Program Files\Microsoft SQL Server\MSSQL10.INSTANCENAME, but all this under the Administrator's folder, so regular users can't have access there, where the
.mdf files are.
In my bootstrapper file, I have the following line to install SQL Express:
<Command PackageFile="SQLEXPR32_x86_ENU.EXE" Arguments='/q /hideconsole /action=Install /features=SQL /instancename=DUBOCALC /enableranu=1 /sqlsvcaccount="NT Authority\Network Service" /SQLSYSADMINACCOUNTS="Builtin\Users" /skiprules=RebootRequiredCheck' EstimatedInstalledBytes="225000000" EstimatedInstallSeconds="420">`
How could I do that, please?
I think it's a very common use, to install a SQL Server Express instance as admin, then running it as a user, but I can't find any useful information which will help me get this working.
thanks a lot everybody in advance, Manuel.