|
I have a production server running SQL Server 2005 Enterprise Edition that has been patched up to SP3. I had this problem in the past but never found the workaround, or I wasn't brave enough to go ahead and try it. I understand that I could do this on a test box and see what happens but I wanted to see if anyone had done this before and might save me the effort. I need to put a second instance of SQL Server 2005 that will be a named instance. As it's going through the System Configuration Check I get the infamous "Edition Change Check (Warning) : To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.". I bypassed that and went ahead with the install. I'm pretty sure that there was just a check that found a different SQL Version and it assumed you were doing something with it instead of adding a new instance. I just wanted to see if anyone knew of any issues and that I did things properly.
(comments are locked)
|
|
I have added secondary instances in the past after the fact. Each one patched to a different level. Have not seen any ill-effects from doing so. I did just the same as you described - continued past that warning. Same here, though it was SQL Server Standard and SQL Server Express in my case. I will note that I have only ever done this on test or development boxes.
Feb 23 '10 at 08:53 PM
TimothyAWiseman
(comments are locked)
|
|
The important thing to be aware of are non-instance aware services, like SSIS. If they are installed, don't add them to the new instance. I would highly recommend that if you do this, you immediately patch the named instance back to the same level as the default instance. If you apply a CU that is post your default instance, apply that CU to the default as well. This is the type of thing that should work, but I have seen quality issues in SQL 2000 with instances at times. I would not trust that all CUs properly deal with this and don't patch something that is potentially shared.
(comments are locked)
|
