2

As I would like to say that we are going to downgrade the SQL Server Standard 2012 SP1 edition with SQL Server Express 2012 SP4 in one Production Server.

For the time being I want to keep the SQL Server Standard 2012 SP1 in that server and I want to install the SQL Server Express 2012 SP4. Until unless the SQL Server Express 2012 SP4 will be not come to production. Till time I want to keep the SQL Server 2012 Standard SP1.

My Question is that at the same time can I install the SQL Server Express 2012 SP4 along with the SQL Server Standard 2012 SP1 in the same Server.

Note : Suppose that as the Running SQL Server 2012 Standard SP1 instance name is ABC. Can I install the same instance name (ABC) of SQL Server 2012 Express SP4 or it will be different.

Md Haidar Ali Khan
  • 6,523
  • 9
  • 40
  • 62

2 Answers2

2

Suppose that as the Running SQL Server 2012 Standard SP1 instance name is ABC. Can I install the same instance name (ABC) of SQL Server 2012 Express SP1 or it will be different.

You cannot have two named instances of SQL Server with the same name on the same pc.

So your options are

  • first uninstall your first instance and then install the second and use the old name for newly installed second instance

  • give the second instance different name, but you can then alias it with the first server's name once you uninstalled the first server

Here you can find information about aliases

sepupic
  • 11,267
  • 18
  • 27
2

My Question is that at the same time can I install the SQL Server Express 2012 SP1 along with the SQL Server Standard 2012 SP1 in the same Server.

Yes installing multiple instances of SQL Server on same machine is fully supported. The only thing is please try to upgrade the instances to SP4 ASAP. SQL Server 2012 Sp1 is not supported.

Suppose that as the Running SQL Server 2012 Standard SP1 instance name is ABC. Can I install the same instance name (ABC) of SQL Server 2012 Express SP1 or it will be different.

No you cannot, two instances cannot have same instance name, you can use ABC_new this may help in making least change in connection string, if required.

Shanky
  • 19,148
  • 4
  • 37
  • 58