MS bulletin 09-004  2 instances SQL Srvr, different versions

Posted on 2009-02-12
Last Modified: 2012-05-06
One server, w2003 fully patched.
2 instances of sql server on the one box.
Instance 1: sql2k sp3a with patches. Realize sp4 must be deployed b4 patching.
Instance 2: sql 2005 sp2 with patches.

I successfully deployed ms04-009 to the 2005 instance but am not able to
deploy the 2k version of the patch to the 2k instance. The message is that
the management tools are the same. Both instances are using the mgmt studio.

Questions are:
1. Can I install sql2k sp4 to instance 1 without harming instance 2?
2. If so, how can I then install the 2k verison of 4-009 to instance 1
successfully and will it harm the 2005 instance?
Question by:kbrown92058
    LVL 42

    Accepted Solution

    should not be problem:
    you can have on same box; 2k 2k5 2008 and all have their patches


    Author Closing Comment

    deployed sql2k sp4 then the patch and all is fine with both instances. Thanks very much

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    745 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

    14 Experts available now in Live!

    Get 1:1 Help Now