Post reply

install SQL 2008 after SQL 2008R2 ?

  • September 23, 2011 at 6:33 am

    #390461

    I have taken over the DBA duties of a guy who left 3 months ago and I have run into an installation issue.

    We have a cluster with 2 nodes on Windows 2008R2. The first instance was SQL 2008. It was installed on one node and then the project was delayed so the 2nd node was never set up.

    For the 3 other instances they used SQL 2008R2, properly installed & configured on both nodes and running fine.

    Now the first project is about to continue and the application is only supported on SQL 2008 (NOT on R2). We tried to complete the SQL 2008 failover cluster setup by adding the 2nd node but hit the issue mentioned in http://support.microsoft.com/kb/2102055.

    As part of the solution, we looked into the installation logs and found no less than 30 installation folders for this instance. None of these logs indicated a successful installation where the instance was brought online, so our only option was to remove the instance on the node it was installed.

    Subsequent attempts to reinstall it have failed : the SQL 2008R2 has upgraded the Browser service and the SQL 2008 installation fails because it cannot install the (older) browser.

    Is there any way this can still be done or is our only option of installing this on another (2008 only) cluster?

    Hans

  • September 23, 2011 at 6:46 am

    #1385670

    I've run into something similar to this before, it might have been with 2005 and 2008.

    Long story short, 2005 was installed and before I could install 2008 as a second instance I had to remove the browser service. The 2008 install would find it and break because it couldn't install its own version. Removing the browser service allowed me to complete the install of 2008.

    I'm not sure how the R2 instance would handle seeing an older version browser if you were to uninstall it.

    Is this a development/test environment?

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • September 23, 2011 at 6:53 am

    #1385677

    Unfortunately this is a production cluster with little room for experiments.

    2008 and 2008R2 share the same major version of SQL Server and therefore some SQL Server components, so they're closely linked.

    Hans

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply