Post reply

SQL Server 2008 Failed to install in a Windows 2008 Cluster

  • July 12, 2011 at 6:11 am

    #253572

    Dear All,

    I have an issue with an installation of a second instance of SQL 2008 on Server 2008R2 cluster.

    Here is my setup. I have a three nodes Windows Server 20088R2. There is a default instace of SQL Server 2008.

    I have created 5 more LUNs to cater for the new SQL instance. Also, I have created a new MSDTC object, and CNO on the DNS server.

    I started the SQL Server New cluster Installation and at the last stage failed. On the Installation progress page it reported that Database Engine Services, SQL Server Replication, and Full text search Failed.

    What do I do now? Do I delete these objects from the cluster and start again? Is there something you can suggest?

    Thank you very much.

  • July 12, 2011 at 6:27 am

    #1351521

    have you checked the install log for details of what failed

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • July 12, 2011 at 6:40 am

    #1351529

    Hello Perry,

    Thank you for your prompt reply.

    I have checked it and it reports that User Has Cancelled the Install. I had to cancel it because on the last screenof the SQL Server installation the Finish button was greyed out, so I had to close the page.

    Do you want to see the log file?

    Regards,

  • July 12, 2011 at 6:53 am

    #1351540

    what install option did you select from the SQL Server 2008 installation center screen?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • July 12, 2011 at 7:06 am

    #1351550

    Perry,

    I have selected New SQL Server failover cluster installation.

    As I said in my previous post it all went fine up to the point Installation Progress page. I got the following message:

    The cluster resource SQL Server (SQL_Name_Instance) could not be brought online. Error: The resource failed to come online due to the failure of one or more provider resources. (Exception from:HRESULT:0x80071736).

    So, I discarded the message, and it took me to the Instal Progress page.

    Thank you

  • July 19, 2011 at 1:11 pm

    #1355114

    SQL 2008 RTM version fails everytime when you install on 2008 R2 windows server

    you have to do slip stream installation

    http://www.mssqltips.com/tip.asp?tip=1902

  • July 20, 2011 at 8:34 am

    #1355680

    4u.chethan,

    4u.chethan (7/19/2011)

    SQL 2008 RTM version fails everytime when you install on 2008 R2 windows server

    you have to do slip stream installation

    http://www.mssqltips.com/tip.asp?tip=1902%5B/quote%5D

    Thank you for sharing the link!



    My blog

  • July 21, 2011 at 9:42 am

    #1356543

    Hello SSCrazy,

    Apologies for the late reply. I was away for few days.

    I am installing with the SP1 integrated. I am aware that running the SQL 2008 installer generates errors, but lets you carry on anyway.

    To cut it short, I had to rebuild the server, for I have not been able to uninstall SQL Server.

    Now, I am stack at the Cluster validation stage, where I get rather weird drive behaviour. I am configuring a second instance of SQL on a three node cluster. The second node (which I had to rebuild), has got all its drives (LUNs on a CLARiiON CX-4) and they are all online. However, under the Failover Cluster mmc the drives from the first SQL instance are all offline. And I think that is why my Cluster validation fails.

    Have I lost you.

    All other resources like MSDTC are fine. All settings on the second node are identical as on the other two nodes (Server 2008R2 with SP1, same hardware Dell blades servers, etc).

    I am running out of time for I have to have the second SQL instance running next week.

    Thank you very much SSCrazy.

Viewing 8 posts - 1 through 7 (of 7 total)

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