I need some help creating a new SQL Server instance such that the data, install, and log folders go in the CommonAppDataFolder, and the binn folder goes under the instance folder under "program files\Microsoft SQL Servers". So far, using TARGETDIR property only, all folders go where TARGETDIR points.
Any help out there? Much appreciated.