MS SQL Express and MS SQL Standard edition installed on same server - possible?

As so far no response to my other question:

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_27373447.html


I have a more straight forward question. On a server (Win 2008) that already has MS SQL Standard edition installed, can you also install MS SQL Express edition to be used by a different application?

I assume not but I could well be wrong?
afflik1923Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
LowfatspreadConnect With a Mentor Commented:
yes you can install multiple versions of sql server

you just need to configure them to ensure that they aren't competing for the same resources..

there are several scenarios where this is good practice as it allows for tailoring of environments more efficiently.
0
 
jawa29Connect With a Mentor Commented:
Hi

Check this link out, it should help.
http://msdn.microsoft.com/en-us/library/ms143694.aspx

Jawa29
0
 
Tapan PattanaikConnect With a Mentor Senior EngineerCommented:
Dear afflik1923 ,

>>>>MS SQL Express and MS SQL Standard edition installed on same server - possible?<<<<<

Yes, it is possible. I have installed both on same server (windows)  , it is working fine.
0
 
vaibhavjaimanConnect With a Mentor Commented:
While installing the other version Just install it under the new instance name and it would work ..
0
 
afflik1923Author Commented:
Many thanks
0
All Courses

From novice to tech pro — start learning today.