My first project is 100% working. It was a client install.
Now I'm attempting to do a Server install. I need to have SQL Server 2008 R2, (SQL), as part of the install. I first installed SQL by itself and had no problems.
When SQL starts it extracts all of the files needed into a new folder.
I then added it to my project using Custom Actions. Tried 2 ways of doing it, 1 at the start & 1 at then end of the install.
Both times I get an error saying that 2 files cannot be found, "Retry or Cancel.
I went looking for the files and they were there in the extracted folder. I noticed that the folder had no privileges. When I gave the Administrator Total Control & then went back and clicked 'Retry' everything installed 100%.
I then did a clean win 7 install and installed SQL again by itself without any problems. I check the extracted folder & I see it also doesn't have any privileges.
How can I give the extracted folder privileges if that's is what's needed? Or am I adding SQL to the project incorrectly.?