Solved

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

Posted on 2011-09-30
5
217 Views
Last Modified: 2012-05-12
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?
0
Comment
Question by:afflik1923
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 50

Accepted Solution

by:
Lowfatspread earned 125 total points
ID: 36890879
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
 
LVL 8

Assisted Solution

by:jawa29
jawa29 earned 125 total points
ID: 36890881
Hi

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

Jawa29
0
 
LVL 21

Assisted Solution

by:Tapan Pattanaik
Tapan Pattanaik earned 125 total points
ID: 36890891
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
 
LVL 4

Assisted Solution

by:vaibhavjaiman
vaibhavjaiman earned 125 total points
ID: 36891275
While installing the other version Just install it under the new instance name and it would work ..
0
 

Author Closing Comment

by:afflik1923
ID: 36975814
Many thanks
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

626 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question