using SQLACCOUNT when distributing SQL Express

[Jassim Rahma]

I have an internet cafe software uses SQL Express 2005 and I am creating a setup package using InstalShield 2008. My plan is to save the MDF and LDF files in my folder not Microsoft SQL Server folder. My folder is C:\Program Files\Jassim Rahma\TICS\Data but InstallShield fails to complete. When contacting InstallShield support they said it's due to folder permission! and they advise to use the SQLACCOUNT. I want to know how can I pass the SQLACCOUNT in InstallShield if my software will be used in different OS, XP and higher?

[Mycroft Holmes]

You're running into UAC issues, they are assuming your SQLACCOUNT has permissions to the program files folders which are locked down unless you are running as admin. I suggest you look into putting your data files into the application data under the user account section (there is an ALLUsers account I am sure), after all this is what it is designed for :rolleyes: