Multiple SQL instances on same server

Posted on 2009-02-20
Last Modified: 2012-05-06
We have a full blown 2005 SQL server that runs an important database for ACCPAC.  We were looking at deploying Endpoint management console on this server due to the low headroom req'd for the application but our environment has about 250 users.  I know there is an embedded database you can install for Endpoint but this is only recommended for under 100 users.  I was thinking of installing a SQL express instance on the server for the database but want to make sure it wont cause any issues with the existing instance.  Unfortunately at this time this is the only server that fits for the endpoint management console.  This server currently runs System Center Console for SAV 10 and is also a Media server for Backup Exec.  There is a SQL instance installed for Backup Exec on this server as well.

Does anyone see an issue with this?  I just want to be sure as I do not consider myself to be a SQL expert by any means.
Question by:Alex Appleton
    LVL 28

    Accepted Solution

    I've used multiple SQL instances, even mixing full SQL instances with SQL Express instances.  No big deal, except that service packs and updates get installed on each instance separately.  This can be a pain if, for example, one of the updates on one of the instances fails and you have to figure out which instance is the culprit.
    LVL 9

    Author Closing Comment

    by:Alex Appleton
    Thanks for the clarification.  Unfortunately others whom I work with disagree with this, however I agree fully and cannot see why it would matter.  

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    I guess it is not common knowledge to most Wintel engineers/administrators: If you have an SNMP-based monitoring system in your environment (and it's common to have SNMP or Syslog) it's reasonably easy to enable monitoring of the Windows Event logs,…
    Recently, I had the need to build a standalone system to run a point-of-sale system. I’m running this on a low-voltage Atom processor, so I wanted a light-weight operating system, but still needed Windows. I chose to use Microsoft Windows Server 200…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    754 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now