I've reviewed these two existing questions:
- Install SQL Server 2008 Express on same machine as normal SQL Server 2008 install?
- Installing SQL Server Express in parallel of Standard
...and I believe mine to not be a duplicate, as the details of my scenario differ slightly (and in an important way). If I'm mistaken please let me know and I'll try to edit my question appropriately.
I already have two named instances of SQL 2014 Standard Edition installed, but no default instance. I wish my default instance to be a SQL 2014 Express Edition installation (MSSQLSERVER).
But I see that the Express installer wants to put its files in
C:\Program Files\Microsoft SQL Server\, where files and folders already exist from the earlier Standard Edition named instance installations (e.g.
.\Client SDK\*, etc.).
If I proceed with the Express installation and accept the default instance root directory (again, which already exists under Standard), will I cause any problems for the currently running Standard Edition named instances?
Or instead should I indicate a new instance root directory to be created (e.g.
C:\Program Files\Microsoft SQL Server Express\) for the new Express installation?
I'd prefer the former if possible, in order to keep everything consolidated, but I also don't want to cause trouble for myself if I can avoid it.