I am trying to embed sql server 2008 r2 express with advanced services along with my application.
Only my application, installed on the same machine as sql server, will be accessing the database. Client computers will be able to generate reports through reporting services.
My client/s who will be installing the application might have no knowledge about SQL Server so the installer or my application should be able to configure everything to make it work properly.
What is the best configuration for this setup?