Home Forums SQL Server 2008 SQL Server 2008 High Availability Convert standalone 2008 r2 server to cluster RE: Convert standalone 2008 r2 server to cluster

  • August 29, 2015 at 5:48 am

    #1823203

    Part-time DBA (8/26/2015)

    Thanks. What confused me a little is that in my test environment I seem to have ended up with what appears to be a working copy of reporting services in the default instance on the equivalent of server 1. If anything, I would have expected it to only be on the server 2 equivalent. I will proceed on the assumption that the URL will have to change, and that I should have a separate instance, this probably won't be a major issue.

    It's possible to have ssrs and clustered engine in same instance name but only on the first node where you install the instance. This is the sequence that would produce a default instance of ssrs with a default clustered sql instance (same with named too), also the error problem you will encounter.

    • You run the install new clustered instance on server1, you select the components to install including shared tools, ssrs and clustered sql database engine
    • You then run the add node on server2 but the ssrs instance is not added
    • You attempt to run the edit feature install on the default instance on server2 but you are told that standalone features cannot be added to clustered installs

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

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