sql 2008 r2 install

Posted on 2011-05-05
Last Modified: 2012-06-27
Hi, I was trying to install a SQL 2008 R2 Cluster on Windows 2008 R2. We already have one instance and this will be an active active cluster.
Can I connect to the virtual name and do the install on the active node and failover from
there and add node?
I was going to login to the primary physical node and do the install and log in to second node and run the setup selecting add node to cluster.
But I wanted to know the difference between the two and if logging in using virtual name would impact the install
Please let me know
Question by:sqlserverdba
    1 Comment
    LVL 8

    Accepted Solution

    It is recommended always to  connect to physical node name while working with clusters over connecting using sql server vritual name.

    The downside of connecting to the virtual name is that your connection will be lost if a failover happens when you are logged in.

    IMO, I don't see any advantage here connecting to the virtual name to perform the install. You can proceed to install the new instance  by logging into the physical nodes.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    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.

    Suggested Solutions

    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    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.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now