Hi,
I have a below case:
Case 1
1. On my machine, I have default installation of SQL server 2008 R2 with instance name SQLEXPRESS already installed.
2. Now, I want to install same version or higher version of Express with below changes
a. It should have different instance name
b. It should have Mixed Mode Authentication enabled
c. It should have Strong Password
d. It should have SQL Server Browser Service set as Automatic (It is disabled in default installation)
e. It should have enabled TCP/IP and Named Pipes.
...
Go to the complete details ...