We help IT Professionals succeed at work.

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

kbrown92058
kbrown92058 asked
on
Medium Priority
1,002 Views
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?
Comment
Watch Question

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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
deployed sql2k sp4 then the patch and all is fine with both instances. Thanks very much
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.