SQL Server 2012 Express checking and silent installation

[PavanKumar1234]

Hi,

We need to perform the following using InstallShield 2013, can someone please guide me:

1. Check if SQL Server Express is installed in the user's machine or not.
2. If present, what is the version that is present.
3. If the version is not 2012, then we need to install SQL Server Express 2012 silently in the background.
4. Give write access on a folder for a particular login (Sql service)
5. After installation of SQL Express 2012, we need to restore a database from a .bak file.
6. After restoring the db, how to run some sql scripts?

Please provide me any link or guidance on how to acheive the above objectives. I am also parallely trying to read the documentation and blogs, but they are vast.

Thanks in advance,
Pavan

[Stefan_Krueger]

For steps 1-3 have you tried the SQL Express prerequisite?

[PavanKumar1234]

Yes, I did try. But it was opening a new SQL Express installation window which users have to click through again manually. I want to avoid any sort of manual interaction. User should just see a screen stating the status of current installation.

Thanks,
Pavan

[Stefan_Krueger]

You could probably edit the PRQ to make it silent.